Aloha. I asked this question a couple of months ago and unfortunately had to step away from my project before resolving the issue. The previous question is closed, so I cannot revive it. Apologies for the duplication
Here’s my issue: How do I take one “entry” from WPForms (i.e.: one line of data) and create two rows in my google sheet?
I’m using WPForms to capture member registration information for a club. Most of the club consists of couples (e.g.: husband and wife), so I’ve created the registration form to gather information on both of them at one time. So far, so good.
The next step is to get the information out of WPForms, and into google sheets so that I can actually use the data. I’ve set up a Zap with the trigger to be a new WPForms entry. And I’m looking at the “Create Spreadsheet Row(s) in Google Sheets” action to hopefully add two rows (one for the husband, one for the wife). But I have NO clue how to do this.
Here’s a link to a gsheet where you can see the ‘before’ and ‘after’ of what I want to happen
In my previous question, one of the responses is to look at the Formatter. However, I’ve looked at this and cannot determine how this can create two rows in my gsheet from one WPForms entry. If this is the solution, please provide some details as I’m not seeing it. Otherwise, please let me know if I can actually create multiple rows in my gsheet from one WPForms item.
In case it matters, I’m using the free version of Zapier
Best answer by robschmidtView original