Hello, I was wondering if someone could help me with this automation…
I use a google sheet as a template to autofill after a google form is complete...the template pulls data from a tab of data that’s emailed to me weekly. I’d like to 1. email the attached document to zapier 2. had zapier add the document to a specific folder and convert it to a google sheet and 3. pull data from the newly added google sheet and add it to the end of the template google sheet.
I’m having trouble with #3 since i’m unable to pull data from the newly updated sheet. can anyone help me out? do you know if this is possible? thanks!
Best answer by andywingrave
Hey there! The best way to approach this is to store a reference for the newly added Google sheet somewhere - You’ll need to know what it is, and some way to identify it in the future.
I suggest considering somewhere to store the name of it so it’s easily referenceable in a different zap. This could be something like:
- Another Google Sheet
- Zapier Storage