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’m going to upsert data to a Postgres database in bulk.

 

I want to have each new row in the DB inserted into a spreadsheet. I know that this is possible, however, I’d also like to create a new spreadsheet after every (let’s say) 100 rows. Is this supported?

 

If it’s not directly possible, I thought one way to achieve this is -- since I’m inserting data in bulk, let’s assume I insert 100 rows at a time. Then, I could have my Zap create a new spreadsheet with every bulk insert.

 

Is this supported with Zapier? Sorry I’m totally new here but I’m really excited!

@gladlydi Unfortunately the Zapier integration with Google Sheets does not allow for a “dynamic” selection of a sheet. So even if you could change to a new spreadsheet after hitting 100 rows You’d have to specify the new sheet manually in the zap, so the automatic part of automation wouldn’t be there for you. 

 

Is there a limit you are running into somewhere that you cannot put it all into one sheet? Or why can you not export from Postgres once you get the data in there? How many rows are you working with here?

Thanks so much for the reply! I wanted to put it into multiple sheets because I want to manually process the data, and it would be nice to have 10 spreadsheets with 100 rows than 1 spreadsheet with an indefinite number of rows if I want to distribute the processing.

 

I could just try and export from Postgres once I get the data in there! I just didn’t know if there’d be a more automated solution.

Terms & Conditions