Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin using Pabbly Connect, start by visiting the Pabbly website. You can access it by typing pabby.com into your browser. Once there, you will need to sign in to your Pabbly account.

Look for the options in the top right corner of the page. If you are an existing user, click on the “Sign In” button. New users can sign up for free to explore Pabbly’s features. This gives you a chance to evaluate how Pabbly Connect can streamline your processes.

2. Creating a New Workflow in Pabbly Connect

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow to automate the collection of YouTube comments into Google Sheets. Click on the plus icon to start a new workflow and name it “Automatically Collect YouTube Comments in Google Sheets”.

Next, select the appropriate folder for your workflow. After naming the workflow, click on the “Create” button to proceed. Now, you need to set up the trigger application, which will be YouTube in this case.

  • Select YouTube as the trigger application.
  • Choose “New Comment on a Channel” as the trigger event.
  • Click on “Connect” to establish the connection.

By setting this up, you ensure that whenever a new comment is posted on your YouTube channel, Pabbly Connect will automatically trigger the next steps in your workflow.

3. Connecting YouTube to Pabbly Connect

To connect YouTube to Pabbly Connect, select your Google account that manages your YouTube channel. After entering your account details, the connection will be created successfully. You will then need to specify the maximum number of results that should be returned.

The max results parameter can be set between 1 to 100, with a default of 20. For example, if you expect to receive 10 comments per hour, set this value to 10. After saving your settings, test the connection to ensure it’s working correctly.

  • Enter the max results according to your needs.
  • Click on “Save” and then “Send Test Request” to check if the setup is successful.

Once the test is successful, Pabbly Connect will be ready to capture all new comments from your YouTube channel.

4. Adding Google Sheets as an Action Step

After setting up the YouTube trigger, it’s time to add Google Sheets as the action step in your workflow. Click on the “Add New Action Step” button and search for Google Sheets. Select the action event as “Add New Row”.

Next, you will need to connect your Google Sheets account to Pabbly Connect. If you have an existing connection, simply save it. Otherwise, click on “Add Connection” and sign in with your Google account. Grant the necessary permissions to allow Pabbly Connect to access your Google Sheets.

  • Choose the Google Sheets document where you want to store comments.
  • Map the fields for the name and the comment from YouTube.

Mapping is crucial to ensure that each new comment is accurately recorded in your spreadsheet. This setup allows Pabbly Connect to automatically add new comments to Google Sheets without manual input.

5. Testing and Finalizing the Integration

Now that you have set up both YouTube and Google Sheets in your Pabbly Connect workflow, it’s time to test the integration. Click on the “Save” button and then “Send Test Request” to confirm that the details are being added to your Google Sheets correctly.

If the test is successful, you will see the comment details reflected in your Google Sheets. This confirms that the integration is functioning as intended. You can adjust the polling time in Pabbly Connect to check for new comments at intervals ranging from 10 minutes to 24 hours.

  • Set the polling time according to your preference.
  • Ensure that all details are being captured in the spreadsheet.

With this final setup, Pabbly Connect will continuously monitor your YouTube channel and automatically add new comments to your Google Sheets, streamlining your workflow significantly.

Conclusion

In this tutorial, we successfully integrated YouTube comments into Google Sheets using Pabbly Connect. This automation saves time and ensures you never miss a comment, enhancing your workflow efficiency.