Connect Hooksy to Google Sheets

#Prerequisites

Before you begin, make sure you have:

• A Hooksy account
• A Google account with access to Google Sheets
• A prepared Google Sheet with headers in the first row

#Step-by-Step Guide

#1. Create a New Webhook

From the dashboard, click Create Webhook to begin the configuration process.

#2. Configure Basic Webhook Settings

On the Create New Webhook page:

• Enter a descriptive Webhook Name

• Select an option from the Source dropdown (choose Custom if the tool of your choice doesn't exist)
• From the Destination dropdown, select Google Sheets
• Click on Connect Google Sheets to authorize access (make sure to click on Select all from the Google OAuth pop-up window)

• Finally, click on Create Webhook

#3. Configure the Source

You have two options to test your webhook:

• Place the Webhook URL directly into the source and trigger a test/sample event
• Send a test webhook event using the GET or POST cURL commands (using a tool like Postman)

Once the test/sample event has been triggered, click on the Check for sample data button.

#4. Prepare Your Google Sheet

Before configuring the destination, ensure your Google Sheet is properly prepared:

• Include headers in the first row
• Avoid using punctuation in spreadsheet or worksheet names

#5. Configure Google Sheets Destination

From Destination Configuration:

1. Click on Select Spreadsheet - Google Picker will pop up (if you see a 403 error, close the pop-up and click Connect Account to authorize access again)

2. Select a sheet from the dropdown

3. Map the fields by selecting appropriate options from each dropdown (you can leave non-required fields blank)
4. Click Save Configuration

#Next Steps

After saving your webhook configuration, you'll be redirected to the webhook page where you can:

• View your webhook details

• Monitor incoming events in the Events tab
• Use the refresh button to fetch the latest events