Skip to main content
Who uses this: Admins building their first Zap with FieldPulse. Availability: All regions; requires a Zapier account.
This walkthrough builds one Zap end to end: a new row in a Google Sheet creates a lead in FieldPulse. It’s a common lead-capture setup — a “Contact Us” form on your website, Facebook, or Instagram writes to a Google Sheet, and the Zap turns each new row into a FieldPulse lead automatically. The order you connect the apps in matters: the source app (Google Sheets) has to come first, then FieldPulse.

Overview

Zapier connects two apps so an event in one triggers an action in the other. In this example, FieldPulse is the receiving app: it pulls in customer records as leads, which land under Company Settings > Customers > Leads. Google Sheets is the trigger app, and its trigger event is a new spreadsheet row. Once you’ve built this Zap, you can repeat the same pattern with any app Zapier supports. New to Zaps? Start with the Zapier Overview for what triggers and actions are.

Before you begin

  • You need a Zapier account. If you don’t have one, create one at zapier.com.
  • Have the source app ready — in this example, a Google Sheet where new rows represent new leads.
  • Know which Google Sheet columns map to which FieldPulse lead fields (for example, which column holds the first name).

Build the Zap

  1. Log in to your Zapier account and start a new Zap.
  2. Search for and select the app you’re connecting to FieldPulse first — in this example, Google Sheets — then FieldPulse as the second app. Connect them in this order: the source app first, FieldPulse second. Zapier dashboard Create your own workflow panel with two Search for an app fields
  3. Choose the trigger — the event in Google Sheets that starts the Zap. For this example, select New Spreadsheet Row. Zapier Connect FieldPulse + Google Sheets page with Select a trigger dropdown
  4. Choose the action — what FieldPulse does in response. Because FieldPulse is the receiving app, select Create Lead. Select an action dropdown open with Create Lead listed under FieldPulse
  5. Select Connect Google Sheets + FieldPulse to link the two apps. Blue Connect Google Sheets + FieldPulse button
  6. Name your Zap so you can find it later, confirm the trigger event is New Spreadsheet Row, and select Continue. Zap editor trigger step with Name your zap field and New Spreadsheet Row trigger event
  7. Choose the Google account to connect (or + Connect a New Account), then select Continue. Choose account step showing a connected Google Sheets account and Continue button
  8. Fill in the remaining trigger options for Google Sheets, then select To Continue, Finish Required Fields.
  9. Select the FieldPulse account to connect and confirm the Action Event is Create Lead, then select Continue. FieldPulse action step with Action Event set to Create Lead and Continue circled
  10. Map the fields: for each FieldPulse lead field, pick the Google Sheet column that fills it. For example, select First Name, then choose the spreadsheet column whose values should populate the FieldPulse First Name field. FieldPulse Create Lead Set up action form listing First Name, Email and Phone fields
  11. On the Test Action screen, run the test to confirm the data flows from the Google Sheet into FieldPulse the way you want. Zapier Test action screen previewing the lead data to send to FieldPulse
  12. When the screen reads Test was Successful!, select Turn on Zap. The connection is now live.
Test was successful! confirmation with Retest action and Turn on Zap buttons Your Zap is working when you add a new row to the Google Sheet and the new lead appears in FieldPulse under Company Settings > Customers > Leads. To bring in leads from another app, repeat these steps with that app in place of Google Sheets.