Before continuing the integration process within Zapier, you’ll need to create a Google Sheet to house your incoming zaps

Within Zapier, name your Zap

Within the “Action” section, choose “Google Sheets”

Within the “Event” section, specify your Event. Choose “Create Multiple Spreadsheet Rows” and tap “Continue”

Select or Connect your Google Sheets Account to Zapier and tap “Continue”

Setup an Action:

• Select “My Google Drive”

• Select your spreadsheet

• Select the appropriate workbook tab

• Map the following Fields:

  • FirstName -> First Name

  • LastName -> Last Name

  • Email -> Email

  • MobileNumber -> Mobile Number

  • Title -> Title (should be the time stamp)

  • Transcript -> Transcript

Tap “Continue”

Tap “Test Action”

Tap "Publish Zap"