Hi All,
I have a Google Form setup, and I’d like the submissions to fill out a row in Google Sheets that has 4 columns. How do I get the entries from the Google Form to fill in particular columns in this row?
I’m using Create Spreadsheet Row, and I notice this is a Create Multiple Spreadsheet Rows, but what I’m looking for would be something more like Create Multiple Spread Columns, which I don’t see.
Best answer by Lightspeed
EDIT: Just clicked Refresh Fields, got it now!
+12Hi
It sounds like you want to just take the info from the form and place it into several columns in a single row.
To do that, just use a regular Create Spreadsheet Row action.
You will then map the information from your trigger step into the columns you want. (first name, last name, email, etc in my example)
Just make sure you have a single row on the top with your headers.
Hope this helps!
+14Hi
Good question.
You can connect a GForm to save to a GSheet without the need for Zaps.
Hi
Good question.
You can connect a GForm to save to a GSheet without the need for Zaps.
You’re right, and that is easy to setup, but what it doesn’t seem to offer is choosing specific parts of the entry and applies them to specfic places. On this particular Google Sheet, I’m only looking for certain parts of the entry to be places in there.
Hi
It sounds like you want to just take the info from the form and place it into several columns in a single row.
To do that, just use a regular Create Spreadsheet Row action.
You will then map the information from your trigger step into the columns you want. (first name, last name, email, etc in my example)
Just make sure you have a single row on the top with your headers.
Hope this helps!
Your Create Spreadsheet Row and mine do not seem to look the same, you have options like First, Last, Email, where as mine just says Webforms Tracker.
EDIT: I missed the part about the top line headers, I have headers, but they’re on line 2, refreshed it all a few times but still not getting
+14Can you post a screenshot with how the first couple rows of your GSheet is configured with the headers?
Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help
EDIT: Just clicked Refresh Fields, got it now!
+6Hi
Awesome! We’re glad to know you were able to get it sorted!
If you have any other questions, please don’t hesitate to reach out in the Community. We’re always happy to help! 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
