Best answer

Updating tab on google sheet from email excel attachment

  • 29 April 2020
  • 1 reply
  • 106 views

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!

icon

Best answer by andywingrave 29 April 2020, 13:39

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +9

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
  • Airtable
  • Zapier Storage