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?

  • 5 April 2022
  • 3 replies
  • 16 views

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


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

Userlevel 7
Badge +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

 

Userlevel 7
Badge +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:

 

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