Scheduled query fails because data table is external (Google Sheets)

AppSheet AppSheet Q&A
,
1

I am trying to schedule my query using data from Google Sheets that updates daily.
However, when setting up the scheduled query I receive error:
Invalid value: XXXXX_raw_order_yesterday is not allowed for this operation because it currently has type EXTERNAL.; JobID: dogwood-XXXXXX

I have carefully followed the steps from De’Lon Dixon as displayed in his video:
https://www.youtube.com/watch?v=gJR9obSJo4k&t=316s

Any idea what I am missing here?

Cheers,

2

Hi @Jannik_Adler !

Please be aware this is a Q&A Forum for AppSheet apps. You would be best served by posting your question into a Google Sheets forum.

1 Like
3

Yeah good point :wink: