Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start the integration process, first, access Pabbly Connect by visiting the official website. You can sign up for a free account, which allows you to explore its features without any initial investment. Once signed up, you will have access to 100 free tasks monthly, enabling you to test various automations.

After logging in, navigate to the workflow page. Here, you will find options to create new workflows. This is where you can set up the integration between Google Sheets and Slack, using Pabbly Connect as the central tool.

2. Setting Up Google Sheets Trigger in Pabbly Connect

To initiate the workflow, select Google Sheets as your trigger application within Pabbly Connect. Choose the event “New or Updated Spreadsheet Row” to ensure that any new entry in your Google Sheets triggers the automation.

  • Select Google Sheets as your trigger app.
  • Choose the event as “New or Updated Spreadsheet Row”.
  • Click the Connect button to generate a webhook URL.

This webhook URL acts as a bridge between Google Sheets and Pabbly Connect. Copy this URL and proceed to your Google Sheets to set up the integration.

3. Configuring Google Sheets for Automation

In Google Sheets, navigate to Extensions and select Add-ons, then Get Add-ons. Search for the Pabbly Connect Webhooks add-on and install it if you haven’t already. Once installed, go back to Extensions, select Pabbly Connect Webhooks, and choose Initial Setup.

In the setup dialogue, paste the webhook URL you copied earlier. Specify the trigger column, which is typically the last data column in your sheet (e.g., Column E). After entering this information, click the Submit button to complete the configuration.

  • Paste the webhook URL in the setup dialogue.
  • Set the trigger column to the last data column (e.g., E).
  • Click Submit to save your settings.

Now, send a test entry from Google Sheets to Pabbly Connect to ensure that the integration is functioning correctly.

4. Sending Data to Slack Using Pabbly Connect

After successfully configuring Google Sheets, return to Pabbly Connect to set up the action application, which will be Slack. Select Slack and choose the event “Send Channel Message” to notify your team of new entries.

To connect Slack, you will need to enter your Slack token. Select whether you are using a user or bot token, and then proceed to authorize Pabbly Connect to access your Slack workspace. Choose the channel where notifications will be sent.

  • Select Slack as the action application.
  • Choose “Send Channel Message” as the event.
  • Authorize access to your Slack workspace.

Once the connection is established, you can map the fields from the Google Sheets response to the message you want to send in Slack. This allows for dynamic messages that update with each new entry.

5. Testing the Integration and Finalizing Setup

To finalize the setup, send a test message to your selected Slack channel. After mapping the fields from Google Sheets, click the “Save and Send Test Request” button in Pabbly Connect. Check your Slack channel to confirm that the message has been sent successfully.

Ensure that the “Send on Event” option is enabled in the Pabbly Connect Webhooks settings in Google Sheets. This will allow automatic notifications for any future entries without needing to send data manually.

  • Send a test message to Slack to verify the integration.
  • Enable “Send on Event” in Google Sheets settings.
  • Confirm successful message delivery in Slack.

With everything set up correctly, your team will now receive automatic notifications in Slack whenever a new entry is made in Google Sheets, thanks to Pabbly Connect.

Conclusion

By following this tutorial, you have successfully integrated Google Sheets with Slack using Pabbly Connect. This automation streamlines your workflow and ensures timely notifications for new entries, enhancing team collaboration and efficiency.