How to Add Canny Votes in Google Sheets Using Pabbly Connect

Learn how to integrate Canny with Google Sheets using Pabbly Connect. This step-by-step tutorial covers setting up triggers and actions for seamless automation. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Canny Integration

To start adding Canny votes in Google Sheets, you first need to access Pabbly Connect. This platform allows you to create automations between various applications, including Canny and Google Sheets.

Begin by visiting the Pabbly Connect website. If you’re a new user, you can sign up for a free account, which offers 100 free tasks each month. After signing in, you will see the Pabbly Connect dashboard, where you can start creating your workflow.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a workflow to automate the data transfer from Canny to Google Sheets. Click on the ‘Create Workflow’ button in the top right corner of the Pabbly Connect dashboard. using Pabbly Connect

• Name your workflow, for example, ‘Add Canny Votes to Google Sheets’.
• Select a folder to save your workflow.
• Click on ‘Create’ to finalize your workflow setup.

Your workflow is now created, and you will see two sections: Trigger and Action. The Trigger is what starts the automation, while the Action is what happens as a result.

3. Setting Up the Trigger with Canny

The next step is to set up the trigger in Pabbly Connect. Click on the arrow in the Trigger section and select Canny as the application.

For the trigger event, choose ‘Webhook Configuration’. Pabbly Connect will provide you with a unique webhook URL that you will use to connect Canny to Pabbly Connect. Copy this URL and head over to your Canny account.

• Log in to your Canny account.
• Navigate to your profile settings and select API.
• Paste the webhook URL in the ‘Add New Webhook’ section and click ‘Add’.

Now your Canny account is connected to Pabbly Connect, and you can proceed to test the integration.

4. Testing the Trigger by Adding a Vote

To test if the trigger is working, go back to your Canny account and add a vote to any of your posts. Once you add a vote, return to your Pabbly Connect workflow, which should show that it is waiting for a webhook response. using Pabbly Connect

After adding the vote, check Pabbly Connect to see if the response has been captured. You should see details about the vote, including the voter’s name and email.

If the response is captured successfully, you will see the vote details in Pabbly Connect. If not, ensure that the webhook URL is correctly set in Canny.

This confirms that your trigger is functional, and you can now set up the action to add these details to Google Sheets.

5. Adding the Action to Google Sheets

Now that your trigger is set up, it’s time to add the action in Pabbly Connect. Click on the plus button to add a new action step and select Google Sheets as the action application.

For the action event, choose ‘Add New Row’. Connect your Google Sheets account to Pabbly Connect by signing in and granting the necessary permissions. Once connected, select the spreadsheet and sheet where you want to store the vote details.

Map the fields from the Canny vote response to the corresponding columns in your Google Sheet. Ensure you include fields like date, post title, username, and email.

Finally, click on ‘Save and Send Test Request’ to test the action. If successful, you will see the new vote details added to your Google Sheets, confirming that the integration works perfectly.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the process of adding Canny votes into Google Sheets. By following these steps, you can efficiently manage customer feedback and enhance your business operations.