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.

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.

Hi @Lightspeed 

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!

Hi @Lightspeed 

Good question.

You can connect a GForm to save to a GSheet without the need for Zaps.

Help: https://support.google.com/docs/answer/2917686?hl=en

Hi @Lightspeed 

Good question.

You can connect a GForm to save to a GSheet without the need for Zaps.

Help: https://support.google.com/docs/answer/2917686?hl=en

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 @Lightspeed 

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

 

@Lightspeed 

Can 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

@Troy Tessalone , I just posted it on one of my responses that I didn’t know that would be an issue. My headers were on Line 2 because I had a title on Line 1. I made the adjustment but still not seeing the options in Zapier.

 

EDIT: Just clicked Refresh Fields, got it now!

Hi @Lightspeed,

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! 😊

Terms & Conditions