Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have tried a few times and am getting stuck. I am looking to have a google sheet of data which is generated from a custom SQL query. But I would like the google sheet to update all the data based on the SQL query running. 

I have found ways to lookup rows and update those rows but I just want the sheet refreshed completely every x time period.

Been trying for a while to get this and just getting lost. Appreciate the help

Hey @sdawes9899,

 

If I’m reading this correctly, you have the Zap performing the function you want correctly but now you are looking for a way to trigger it at on a regular schedule. If this is the case, the Schedule trigger by Zapier may be what you’re looking for. This would allow you to set the Zap to trigger every hour, day, week, or month based on what you select. You could also have multiple copies of the Zap to trigger at different intervals.

If you need a more custom interval than this you could also use the Delay feature. To do this I would create a spreadsheet with all the times I want the Zap to trigger listed. The trigger would be adding new rows to the spreadsheet and the Delay step would be used to delay until the time in the spreadsheet.

Let me know if these will work for your case!

 

Happy Zappin’ !

XRay

@XRayTech Actually I do not. I have the SQL being correct but it is not creating the full spreadsheet worth or data NOR auto updating it. As when looking at the drop downs it just states 1 row when using custom SQL

 

 

@sdawes9899  Since you can only look at one row at a time this might not be very feasible. One option would be to use the Looping function to loop through the SQL rows and update the GSheets rows one at a time. The Looping function is currently limited to 500 loops though, so depending on the size of your database you may have to have multiple Zaps for rows 1-500, 501-1000, etc. This is not the most practical, but may be actionable. 

@XRayTech Ahh ok. That makes sense now. Thank you for clarifying

Terms & Conditions