Sending Product Information to Google Sheets using Zapier (v3 and earlier)

Superceded: This technique applies to Gravity Forms Zapier Add-On version 3 and earlier.

Description

This step-by-step example shows you how to send a list of product information, as collected from a form, to a Google spreadsheet, using the Zapier Add-On.

Background

As of version 3 of the Zapier Add-On, product information is sent to Zapier as an array, use of which is what this example demonstrates. This change allows you to use the option in Zapier that creates new rows with line item support.

In addition, the list data is also still being sent as a serialized string, simply to maintain backwards compatibility.

Requirements for this Example

  • A form that has product fields
  • Gravity Forms Zapier Add-On v3 or higher, available from the Downloads page for appropriately licensed users
  • A Zapier account
  • Access to Google Docs

Step-By-Step

Below are the steps to follow so that product data will be sent to a Google spreadsheet as separate line items.

  1. While viewing the Form, mouse-over the Settings link towards the top and select Zapier.
Zapier Feeds List - No Feeds

  1. Click the Add New button to add a new feed.
  2. Name your “Zap”.
  3. Open a new browser window and log into your Zapier account.
  4. Make a Zap!Click the Make a Zap! button towards the top.
  5. The option to Choose a Trigger App appears. Select Gravity Forms as the application.
  6. Choose New Form SubmissionChoose New Form Submission as the trigger and click the Save + Continue button.
  7. Copy URLAt this point, you are presented with a URL for the new Zap. Copy this URL and return to the window for your Form’s Feed Setup.
  8. Paste the URL into the Webhook URL field.
  9. Click the Save Zapier Feed button.
Zapier Feed Settings for Modern Feeds generated by Zapier
  1. Return to the browser window for setting up the Zap in Zapier.
  2. Ok, I did thisClick the Ok, I did this button.
  3. Sample SubmissionThe next screen displays sample data of how a submission from your Form would appear. Click the Continue button.
  4. The option to Choose an Action App displays. Select Google Sheets as the application.
  5. Google Sheets ActionSelect the option Create one or more new rows in a specific spreadsheet (with line item support). If you do not see that option, you may have to reveal it by expanding your choices with the “show less common actions” link. Click the Save + Continue button.
  6. Connect to the Google Account where your spreadsheet exists and click Save + Continue. If you have not already created a spreadsheet for the product information, do so now because it is needed in the next step.
  7. Row MappingSelect the spreadsheet and the worksheet.
  8. Product DataThe row headers in the spreadsheet now display. The Product Data to use for list items displays in the field list with Products/ pre-pending the data. Because Zapier 3.0 is backwards compatible, you will still see individual fields for the product information. These do not work as line items and can be ignored. Map the product fields to your row header. If you notice data you didn’t include in your spreadsheet, you can simply add a new header to your spreadsheet and click the Refresh Fields button and the new row will be pulled in for you to map. Click the Continue button once your mapping is complete.
  9. At this point, a test row may be sent to your spreadsheet for your review. You may skip this step if you wish.
  10. Click Finish.
  11. Product DataName your zap and turn it ON.
  12. Your Zap is now ready to process form submissions to populate your spreadsheet.