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

[Jannik_Adler]

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, 

[WillowMobileSys]

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.

[Jannik_Adler · Accepted solution]

Yeah good point 😉