Question

Can I make a Zap that automatically links Google Form to a Google Sheet?

  • 23 September 2023
  • 5 replies
  • 27 views

Every time I sell a product, I need to create a new google folder that has a customized google sheet and a customized google form. My zap does that, but I also need to set it so the responses from the new form go to the new sheet, and as far as I can tell there isn’t an action for that.

I see there are ways to set up an action where if the Form gets a new response, a new row gets added to a specific Google Sheet. Problem is, that would count as a new task every time someone submits the form, and I’m going to be getting so many Form responses that that isn’t practical for me. I can link the two manually through Google Forms, but it sure would be nice not to have to if there’s a way to automate that without eating through all my allotted tasks.


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

5 replies

Userlevel 7
Badge +14

Hi @Katy R 

Good question.

GForms can be natively linked to a GSheet: https://support.google.com/docs/answer/2917686?hl=en

Hi @Katy R 

Good question.

GForms can be natively linked to a GSheet: https://support.google.com/docs/answer/2917686?hl=en

 

Yes. But the question is, can I get Zapier to do the linking for me? Or do I have to just manually change the setting through Google Forms each time?

Userlevel 7
Badge +14

@Katy R 

Each new GForm would need to be it’s own Zap that would need to be manually configured.

So if you have to manually configure a Zap to connect to a GSheet, then why not just manually connect the GForm to the GSheet instead?

@Katy R

Each new GForm would need to be it’s own Zap that would need to be manually configured.

Sorry, can you explain what that means? Why would I need a whole separate Zap to make a form?

For the “why not just manually connect the GForm”? I can. And I do. But the problem is, I need to create a separate copy of the form for every client; they will be using it to collect their own data and then the sheet I provide will automatically sort and process that data. So manually connecting it isn’t a one-off process, it needs to be done again every time I get a new client.

If the answer is “no, you can’t do that with Zapier” I understand, I just wanted to check and make sure I wasn’t missing anything. Right now my Zap automatically creates the files I need, and names them, and moves them to a new folder for the new client, but then I still have to go in manually every time and link the form to the sheet. I just wondered if I could have the Zap do that automatically instead.

 

 

Userlevel 7
Badge +14

@Katy R

If it is possible, it likely involves the GForms API: https://developers.google.com/forms/api/reference/rest