Google Sheets

​

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

1

Install the 'Webhooks for Sheets' Plugin

To install the “Webhooks for Sheets” plugin:

1. Go to Google Workspace Marketplace: Visit this link.
2. Click Install: Follow the prompts to add the plugin to your Google Sheets.

Installing Webhooks for Sheets

2

Configure the Plugin in Google Sheets

Once the plugin is installed:

1. Open the Plugin: In your Google Sheets, you will see the Plugin appear on your sidebar on the right.

Adding the Plugin to Sheets

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

3

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.

Configuring Webhooks for Sheets

​

Setting up Periskope

1

Navigate to Webhooks Page

Log into your Periskope account and go to Settings > Webhooks.

2

Add a new Webhook

Click on Add Webhook. A form will appear where you can enter the webhook details.

3

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.

4

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.

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.

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

2. Modify the Webhook URL:

   • Copy the base URL provided by the “Webhooks for Sheets” plugin.
   • Replace gid parameter with the gid 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.

1. 👥 chat.created 🔗
2. 💬 message.created 🔗
3. 💬 message.updated 🔗
4. 💬 message.deleted 🔗
5. 💬 message.ack.updated 🔗
6. 😀 reaction.created 🔗
7. 😀 reaction.updated 🔗
8. 🏷️ ticket.created 🔗
9. 🏷️ ticket.updated 🔗
10. 🏷️ ticket.deleted 🔗