Streaming live at 10am (PST)

Need your help! Form to Google Sheets via Zapier


#1

Hey guys. I really need your help.

I managed to set up a "zap" that adds new form submissions to my Google Sheet, however... Since the form is on a dynamic collection page, I can't separate the submissions based on which collection item site it was submitted from. But I get all submissions from all collection items in the same spreadsheet.

The solution I have now, is to have the user that is filling out the form type in the name of the collection item in the form, and then I can sort the submissions in the spreadsheet, but there got to be a better way to do it. Do you know if there is a way to have the form add which collection item it was used from, or something like that?

I really hope you can make sense of what I'm writing... Here is the Zap I'm using now: https://zapier.com/zapbook/zaps/2242/send-webflow-form-data-to-google-sheets/

So basically i need the "zap" to either make a new tab in the spreadsheet based on the collection item, or make a new document for every item?

All help is very much appreciated ! :slight_smile:


#2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.