I want to run a query on a schedule and save it to a new google sheet in a specified folder every day. I would want to sheet to be name ABC_{DATE_TIME} where date time would be the date and time it was created.
When using googles connected sheets it overwrites the data and it is limited 50K rows so I am looking for a no or low code solution using zapier.
Thanks
+14
Hi
Good question.
Make sure to review the help articles for using GSheets in Zaps to be aware of record limitations. (10K)
https://zapier.com/apps/google-sheets/help
You may be able to get around this using the GSheets API via these GSheet actions:
I may have mis-spoken a bit. I am ok with saving it as a csv if GoogleDrive. The main thing I needs is somewhat larger datasets to be in files accessible outside the database. I want to make sure a new file gets created with each export and that it runs daily.
Any help would be appreciated
+14
Hi
Can you post screenshots with how your Zap steps are outlined and configured to give us more context?
Zap 1
Zap 2
I keep trying to get step 2 to work and that does not seem to work for me. It doesn’t seem to be running my query correctly. It is a simple select statement
+14
We would need to see screenshots with how your Zap steps are configured to have full context.
Thanks so much for offering to help. Let me try to provide context and whatever else I can.
At 10:00 am daily
Run a query against Bigquery database (Example)
SELECT * FROM `my-project.my-data-set.mytable` WHERE my_date_field = CURRENT_DATE('America/New_York')-2
Take results and save in a folder called Inbound FBA Details(which I can create in my Drive) in a file called
inbound_fba_details{-DATE-TIME}.csv where the DATE-TIME is replaced with the date and time the file was created.
It can be either a csv file or a google sheet.
But sometimes I may have over 100K results.
+14
Looks like this will create a Job.
Can you show screenshots of the DATA OUT from testing the step?
You may have to add a Delay, this Zap action: BigQuery - Get Rows for Job Completed
Or use a different Zap with this trigger: BigQuery - Query Job Completed (with Row Dat)
NOTE: Results with 100k rows may exceed the data limits for Zap steps.
I am not that familiar as this is my first real foray in zapier and I just can’t seem to get it working. (This query returns a about 4K rows), I will looks into what you
This keeps happening when i get to test.
+14
Guesses:
Perhaps try opening a ticket with Zapier Support for possible guidance in troubleshooting: https://zapier.com/app/history/
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
