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.

Hello amazing community!

We add monthly classes Google spreadsheets added to a Google Drive where the students data are in. We need a zap to row-by-row copy then transfer all the data over to a Master Data Google Sheet.

We then have another Zap that monitors the Master Data Google Sheet, when a new row is created on this sheet. So it’s a step 2 zap that works fine. 

The issue I’m having is for the step 1. There’s no exact spreadsheet ID since it’s a monthly spreadsheet when I use the LOOKUP. What’s your best workaround to get our monthly data transfer to our master sheet? 

Hi ​@ronee, welcome to the Community! 🎉

Sorry you’ve not had a reply here yet. Were you able to figure out a way to achieve it? If you managed to get it sorted, we’d love to hear more about the approach you took - I’m sure there must be lots of folks wanting to build something similar! 

And if you’re still stuck, how many rows of data would need to be transferred?

If it would be less than 1,500 rows you could try this sort of approach:

  • New File in Folder (Google Drive) trigger to run when you move the monthly spreadsheet file into a specific folder - that should give it’s ID.
  • Have a Get Many Spreadsheet Rows action to find the rows in that spreadsheet (limited to 1,500 rows).
  • Then use a Create Multiple Spreadsheet Rows action to copy the rows over to the main spreadsheet.

Hope that helps. Let us know how you’re getting on, want to make sure you’re all set! 🙂

Terms & ConditionsAccessibility statement