How to Create HubSpot Blog Post from Google Sheets Using Pabbly Connect

Learn how to automate HubSpot blog post creation from Google Sheets using Pabbly Connect with this detailed tutorial. Step-by-step instructions included. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create a HubSpot blog post from Google Sheets, you will first need to access Pabbly Connect. This platform will facilitate the integration between Google Sheets and HubSpot CRM.

Visit the Pabbly Connect homepage by typing the URL Pabbly.com/connect. Here, you can either sign in if you’re an existing user or click on ‘Sign up for free’ to create a new account. New users will receive 100 free tasks every month to explore the platform.

2. Creating a New Workflow in Pabbly Connect

After logging into Pabbly Connect, navigate to the dashboard to create a new workflow. Click on the ‘Create Workflow’ button, which will prompt you to name your workflow. For this integration, name it ‘Create HubSpot Blog Post from Google Sheets’.

Once named, select the appropriate folder for your workflow. After creating the workflow, you will see two sections: Trigger and Action. The Trigger will be Google Sheets, and the Action will be HubSpot CRM. This setup allows you to automate the process of blog creation.

3. Setting Up Google Sheets as the Trigger

In this step, select Google Sheets as your trigger application in Pabbly Connect. The trigger event you need to choose is ‘New or Updated Spreadsheet Row’. This event will trigger the workflow whenever a new row is added to your Google Sheets.

After selecting the trigger event, you will be provided with a webhook URL. Copy this URL as you will need it to connect your Google Sheets to Pabbly Connect. Now, go to your Google Sheets and set up the Pabbly Connect webhooks add-on.

• Go to Extensions > Add-ons > Get Add-ons.
• Search for Pabbly Connect Webhooks and install it.
• After installation, refresh your spreadsheet.

Once refreshed, navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL you copied earlier and set the trigger column (usually the column where the content is entered).

4. Creating a Blog Post in HubSpot CRM

Next, you will set HubSpot CRM as your action application in Pabbly Connect. Choose the action event ‘Create Blog Post’. Click on ‘Connect’ and select your HubSpot account.

In the setup, you will need to map the fields from Google Sheets to HubSpot. For example, map the blog title and content from your Google Sheets to the corresponding fields in HubSpot. This dynamic mapping ensures that every new entry in Google Sheets creates a new blog post in HubSpot CRM.

• Map the blog title to the ‘Name’ field in HubSpot.
• Map the blog content to the ‘Post Body’ field.
• Optionally, provide a meta description and slug for the blog post.

After mapping these fields, click on ‘Save and Send Test Request’ to create the blog post. You should see a successful response indicating that the blog was created.

5. Publishing the Blog Post and Updating Google Sheets

Now that the blog post is created, the next step is to publish it. Add another action step in Pabbly Connect and select HubSpot CRM again. This time, choose the action event ‘Publish or Unpublish Blog Post’.

Map the blog post ID received from the previous HubSpot action to this step. Additionally, you can add a delay action to give HubSpot some time before publishing the blog. Set the delay to one minute.

Select the blog ID from the previous step. Set the action to ‘Schedule Publish’. Click on ‘Save and Send Test Request’.

Finally, to update the Google Sheets with the blog URL, add another action step for Google Sheets and select ‘Update Cell Value’. Map the URL received from HubSpot to the corresponding cell in your Google Sheets.

Conclusion

Using Pabbly Connect, you can seamlessly automate the creation and publishing of HubSpot blog posts directly from Google Sheets. This integration not only saves time but also ensures that your blog content is consistently updated and published efficiently.