I have a Google Sheet that is frequently updated with new sheets (tabs). I’d like to be able to pull those updated rows (no matter WHICH sheet they’re in) and copying them over to the master sheet (tab) within the same Google Sheet. Is that possible?
What this looks like:
- Sheet B is created with a new row → Sheet A (master) is then updated with the new row from Sheet B
- Sheet C is added later and the same process as above should work the same with updating Sheet A
What I don’t want to do is to have to keep going into Zapier to add the names of the new sheets into the Zap. I can’t use Google Sheets import function for the same reason—that’d mean I would have to consistently go into each new sheet to add the import function.
Best answer by SamBView original