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.

Answer

Updating tab on google sheet from email excel attachment

  • April 28, 2020
  • 1 reply
  • 121 views
S

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

andywingrave
Forum|alt.badge.img+9
  • andywingraveZapier Solution Partner
  • Zapier Solution Partner
  • Answer
  • April 29, 2020

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
Terms & ConditionsAccessibility statement