Follow

Updating Lookup List from Google Drive / Sheets using Zapier

Using a service like Zapier can offer a quick and efficient way to integrate FastField with other 3rd party software services/platforms.   This article describes how to setup a Zap to "trigger" a Lookup List update in FastField from a Google Sheet residing on your Google Drive.

 

Prepare your Google Sheet

Before setting up your Zap, you will need to prepare your sheet with information to tie it to FastField.  Login to your FastField portal and open the Lookup List admin scree.  Next, hover above the list name.  You will see a long id as shown below:

In Google Drive, enter the Lookup List Id into the description field of the Google Sheet, as shown below:

Step 1 - Setup Your Google Drive Trigger:

Once you have started your New Zap, add Google Drive as the triggering system:

 

Choose "Triggered when an Updated File (Google Sheet) is added to GoogleDrive." as your trigger action and click Continue:

 

Zapier will then ask you to connect to your Google Drive account:

Click Continue to specify the Google Drive Folder that will be used to pickup lookup data files:

Step 2 - Add a Webhook Action to Authenticate with Your FastField Account

Select the Post option for the Zapier action:

Set the following on the POST parameters (note: be sure to provide your own credentials for your user account)

Step 3: Setup a Webhook Action to Upload the Lookup List File to FastField:

Select the Post option for the Zapier action:

Setup your POST parameters as shown below (Note: Be sure to include the Data Session Token returned from your step 2 (Authentication Call) as a header in this step.)

 

 

Click Continue to Publish your Zap.

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk