Scheduling google sheets refresh via query?

  • 188Views
  • Last Post 3 weeks ago
  • Topic Is Solved
1
votes
Stew Stremel posted this 22 January 2019

Is it possible to shedule a google sheet to refresh daily using the query?  I know we can create schedule action/events in the google api but don't know if it is possible to schedule your query object - this would be a great feature to add if not...

 

Cheers,

  • Supported by
  • Richard Butterworth
Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 22 January 2019

Unfortunately not, Skyvia Query Tool and Skyvia Query Google Sheets Add-on do not support query scheduling at the moment.

We will definitely contact you as soon as this functionality is supported.

 

Best regards,

Mariia

1
votes
Fernando Torres posted this 16 September 2020

Hi Marria,

Do you have refresh about

Is it possible to shedule a google sheet to refresh daily using the query?  I know we can create schedule action/events in the google api but don't know if it is possible to schedule your query object - this would be a great feature to add if not...

on date  to Sep 2020?

  • Supported by
  • Richard Butterworth
0
votes
Mariia Zaharova posted this 16 September 2020

Hello Fernando,

 

Unfortunately not, no news so far. Skyvia Query Tool and Skyvia Query Google Sheets Add-on do not support auto-refreshing and scheduling for now.

 

 

Best regards,

Mariia

0
votes
Richard Butterworth posted this 3 weeks ago

Hi Mariia - any update on this feature, please? I see this thread is a couple of years old now. Are there any firm plans to add scheduling to the app (like other tools do... e.g. 'Data Connector for Salesforce')?

Thanks,

Richard

0
votes
Mariia Zaharova posted this 3 weeks ago

Hello Richard,

 

Skyvia Query Google Sheets Add-on still does not support auto-refresh.

However, recently we have improved Skyvia Export package and now you can use custom queries in the Export package. This means, that you can configure your Export tasks to execute custom queries and set up a schedule for this package to run automatically. Please take a look at these links:

https://docs.skyvia.com/data-integration/export/how-to-create-export-task.html

https://skyvia.com/blog/sql-statements-and-custom-queries-in-export-packages

 

Best regards,

Mariia

 

Close