Skip to main content
Question

Setting up a WPForm to collect data and move it to a Google Sheet. How do I parse info from a single WPForm entry into two rows in Google Sheets?


Aloha. Just taking a look at Zapier integration of WPForms and Google Sheets. When I look at https://zapier.com/apps/wpforms/integrations/google-sheets I see two ‘zaps’ available to connect WPForms and Google Sheets:

  1. Save new WPForms entries to a Google Sheets Spreadsheet
     
  2. Create new Google Sheets rows with new WPForms entries

I can’t find a description of what the difference is with these two zaps. The second zap’s name implies that I can take a single WPForm entry and create multiple rows from it. Is that correct?

Here is what I’m looking to accomplish. I’m setting up a WPForm to collect the usual info (name, phone, email, etc.) for a club membership. And after the info is collected I move it over to a Google sheet so that I can use the data. But, most of our members are couples (husband and wife), and there is no way within WPForms to collect data on multiple people with one form and store the info as two separate entries (like they will be in the google sheet). I’m hoping that one of the zaps listed above lets me parse info from a single WPForms entry into two rows in a google sheet.

Mahalo (thank you) for your assistance

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Harry Z 

Good question.

Check out the available Zap triggers/actions for each app.

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

WPForms: https://zapier.com/apps/wpforms/integrations#triggers-and-actions

 


Troy Tessalone
Forum|alt.badge.img+14

@Harry Z 

Check out using Formatter steps to handle and transform the line item data.

GSheets can be used to create Row(s) from array line item data:

 


  • Author
  • Beginner
  • 6 replies
  • April 7, 2022

Mahalo @Troy Tessalone for the quick responses.  My webmaster got Zapier installed late today so I’ve only played with it a little bit so far. I’ll update in a day or two when I’ve had a chance to work with it a little more.

 

Harry Z