Creating Sell leads from Google spreadsheets and forms

What's my plan?

If you create spreadsheets and forms in Google Sheets to collect information about new leads, you can, for example, create leads in Sell from that data using the Zapier integration (see Using Zapier with Sell). 

Here's what you'll need to get started:

• A Zapier account
• A Google spreadsheet for collecting lead data

Setting up your Google spreadsheet

Before you set up the Google Sheets to Sell integration in Zapier, you should have set up a Google spreadsheet for collecting your lead data. 

To create a Google spreadsheet for lead data

1. Create a new spreadsheet in your Google account.
2. Add the field titles to the first row of the spreadsheet (as shown below). 
3. Add sample data for each of the field titles (columns) that you add to your spreadsheet. 

Setting up the Google Sheets and Zendesk Sell integration

The next step is to set up the Google Sheets to Sell integration in Zapier.

To set up Google Sheets to create leads in Sell

1. Create a Zapier account, if you don't already have one.
   • Follow the steps described in Using Zapier with Sell.
   • Or, go directly to Connect Google Sheets + Zendesk Sell.
2. On the Connect Google Sheets + Zendesk Sell page, provided you've set up a Zapier account and you're signed in, you can click Get Started–Use this Zap!.
   

   

3. Click Connect Google Sheets + Zendesk SellIntegrations.

    

4. On the next page, select the New or Updated Spreadsheet Row trigger.

   

5. Next, you'll be prompted to connect your Google account. Click Connect an Account.

    

6. Sign in to your Google account and authorize the connection between Google and Zapier.  

   

7. Select a Google spreadsheet and worksheet as the source of new lead data. 

   

8. On the next page, you need to choose the action that creates the lead in Sell. Select Create Lead. 

   

9. Click Edit Template to map the columns in your Google sheet to the corresponding fields in Sell.

   

10. The last step is to activate your Zap. Enter a name for it, then click On.

    

The data collected from your Google spreadsheet is automatically synced to your Sell account and new leads are created when a new row is added to the spreadsheet.