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.

Dear forum,

I’m trying to find a way to autofill a template Google Sheet.

The template Google sheet contains a to do list, that needs to be copied into a separate Google Sheet every time someone fills out a Google Form. The to do list itself stays the same, but I’d like to add some info to it that is derived from the filled Google Form.

How can I pull results from the form (or from the responses sheet of the form) into a template Google Sheet containing the to do list?

I can’t seem to figure it out. I hope you can help me find a way.

Hi @Gemma_KRAGT ,

 

You can do that by using the step from Google Sheets “Copy Worksheet” and use it to create a new worksheet. After that step you can use the step “Update Spreadsheet Row” and inout the sheet ID you just created, then include the information you need. 
 

If this helps, please mark it as Solved

Dear MohSwellam,

Thank you for your answer. I think the solution that you propose is a manual workaround. I want it to be automatically.

So when the Google Form is filled in (and a row is added to the Repsonses spreadheet) it should also automatically make a new spreadsheet from a template, with information from the new response.

Zapier has these autofill functions for filling in templates of Google Docs and Google Slides with responses from Google Forms, but apparently not for a Google Sheet template (the to do list I’m talking about). I’m looking for a workaround with the same result…

Cheers,

Gemma

Hi @Gemma_KRAGT 

 

Nothing in what Im proposing is manual :) 

 

The Zap steps will be as follows:

  1. Trigger > Google Forms > New Response
  2. Action > Google Sheets > Copy Worksheet (or Copy Spreadsheet, whichever works for you)
  3. Action > Google Sheets > Update Spreadsheet Row

 

Please see below screenshots

 

Hope its clear now
 

 

Sorry for my false accusation, and thank you so much for your explanation!! This worked 🙂. However I split it in two steps (first update spreadsheet row and then copy the spreadsheet), because I use the free version of Zapier….

 

Thank you!

Glad to hear this worked for you @Gemma_KRAGT and thanks for sharing how you were able to workaround this on the free plan! 🙂

Terms & Conditions