# Connect to Google Sheets

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

{% hint style="info" %}
View our [Zapier Template Document](https://docs.google.com/spreadsheets/d/1qyXyO9q1P9JCNuDglcHlDlmOWP4Fk86AAyCYlbYleDo/edit#gid=0) and copy the file into your organization’s Google Drive
{% endhint %}

2. Within Zapier, name your Zap

<figure><img src="https://lh7-us.googleusercontent.com/sRInWDSmKQiYRRwzOyY0Ul0-MWQNAngWuhi48JZddMRiy9314fMhU-6emwiacOhZNwSc1nBiGgqdHYh57a9ZHBoKLDcEHXfv_wSiw4eJo0_Vs1XI29uPYdfVOcWqMEAYo9z3o483IZy5RXZuZ0LMDq4" alt=""><figcaption></figcaption></figure>

3. Within the “Action” section, choose “Google Sheets”
4. Within the “Event” section, specify your Event. Choose “Create Multiple Spreadsheet Rows” and tap “Continue”
5. Select or Connect your Google Sheets Account to Zapier and tap “Continue”
6. 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

<figure><img src="https://lh7-us.googleusercontent.com/f2uHn1vmwTFYcn_OGAcWORfZGn7NuCGu0ibQpFJv-4CgaJdmOSLPwtLv_pX0kwApG7-_3jA3i-c6REF-Ab_q3qx9lgWLK60U_F-8yraKiYeuB6SFEJ-w5stPVmwcSTtAbZ8SNUUDORSJmzsXo_p1JuE" alt=""><figcaption></figcaption></figure>

7. Tap “Continue”
8. Tap “Test Action”
9. Tap "Publish Zap"

<figure><img src="https://lh7-us.googleusercontent.com/dweuRs6Him1TDKcDZLiCRBCFEqUw4vRcBjpUCUbs-oI3mj8xrs3hVUyYmm85YXGJURwo2e28ACsJRm-6Q7zee4oUYZL77krehqAbd-Meomv_kQp8V6-JQbZU65d_pylLp-MX6nGbRTUZ2tzFwpTpze0" alt=""><figcaption></figcaption></figure>