Google Sheets
Guide to connect Periskope with Google Sheets using webhooks
Introduction
This guide explains how to connect your Periskope platform to Google Sheets to automatically update your sheets with event data from Periskope using webhooks.
Prerequisites
- A Google Account
- A Periskope Account
- Webhooks for Sheets Plugin installed in your Google Sheets
Setting up Google Sheets
Install the 'Webhooks for Sheets' Plugin
To install the “Webhooks for Sheets” plugin:
- Go to Google Workspace Marketplace: Visit this link.
- Click Install: Follow the prompts to add the plugin to your Google Sheets.
![Install Plugin](https://mintlify.s3-us-west-1.amazonaws.com/bharatkumarramesh/integrations/google-sheets/install-plugin.jpeg)
Installing Webhooks for Sheets
Configure the Plugin in Google Sheets
Once the plugin is installed:
- Open the Plugin: In your Google Sheets, you will see the Plugin appear on your sidebar on the right.
![Configure Plugin](https://mintlify.s3-us-west-1.amazonaws.com/bharatkumarramesh/integrations/google-sheets/google-sheets-plugin.png)
Adding the Plugin to Sheets
- Follow Plugin Instructions: The plugin will guide you through setting up a webhook receiver within your sheet. Watch this video for a detailed walkthrough.
Webhooks for Sheets Plugin Installation Tutorial
Obtain Webhook URL
At the end of the setup, “Webhooks for Sheets” will provide you with a unique URL. Copy this URL. This will be used to receive data from Periskope.
![Copy Webhook URL](https://mintlify.s3-us-west-1.amazonaws.com/bharatkumarramesh/integrations/google-sheets/copy-url.png)
Configuring Webhooks for Sheets
Setting up Periskope
Navigate to Webhooks Page
Log into your Periskope account and go to Settings > Webhooks
.
Add a new Webhook
Click on Add Webhook
. A form will appear where you can enter the webhook details.
Configure Webhook Endpoint
- Paste the URL: Enter the URL provided by the “Webhooks for Sheets” plugin into the ‘Webhook endpoint’ text box.
- Select Events: Choose the events you wish to receive data for. It’s recommended to select one event per table to keep data organized.
You should select only one event for one Sheet. To send multiple event data to different sheets using the same URL, see the section below on modifying the gid
parameter.
Save Settings
Confirm and save your webhook settings. This action will activate the webhook, and Periskope will start sending data to your Google Sheet as specified events occur.
![Setup Webhook](https://mintlify.s3-us-west-1.amazonaws.com/bharatkumarramesh/integrations/google-sheets/webhooks-modal.png)
Setting Up Webhooks in Periskope
Sending Multiple Events
To send different events in the same document, you need to have multiple sheets and then modify the gid
parameter in the URL provided by the “Webhooks for Sheets” plugin. Each sheet in a Google Sheets document has a unique gid
value in the URL.
-
Obtain the
gid
of each sheet:-
Open the Google Sheets document.
-
Navigate to the desired sheet.
-
The
gid
is found in the URL after#gid=
.GID parameter at the end of Google Sheets URL
-
-
Modify the Webhook URL:
- Copy the base URL provided by the “Webhooks for Sheets” plugin.
- Replace
gid
parameter with thegid
of your particular sheet. - Create a new webhook in Periskope.
Example
If your base URL is https://webhooks.google.com/sheets/{your-unique-id}
and you want to send message.created
events to a sheet with gid=123456
, modify the URL to:
https://webhooks.google.com/sheets/{your-unique-id}?gid=123456
Repeat this for each event and sheet combination.
Result 🚀
- Your Google Sheets will automatically update with data from Periskope in real-time as specified events occur.
- This setup enables efficient tracking and management of client interactions directly from your spreadsheet.
That’s it! You have now integrated Periskope with Google Sheets using webhooks. Your Google Sheets will now receive real-time updates from Periskope based on the selected events.
Events
Currently, we support the following events for Google Sheets integration.
Was this page helpful?