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

View our Zapier Template Document and copy the file into your organization’s Google Drive

1. Within Zapier, name your Zap

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

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

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

4. 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

1. Tap “Continue”

2. Tap “Test Action”

3. Tap "Publish Zap"