How to Create Shopify Blogs from Google Sheets Using Pabbly Connect

Learn how to automate Shopify blog creation from Google Sheets using Pabbly Connect. Step-by-step guide with detailed instructions and UI elements. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

Setting Up Pabbly Connect for Google Sheets and Shopify Integration

To create Shopify blogs from Google Sheets, the first step is to set up Pabbly Connect. This integration will allow you to automate the process of creating blog posts whenever a new row is added in Google Sheets. Begin by signing into your Pabbly Connect account. If you’re a new user, click on the sign-up button to create an account and receive 100 free tasks.

Once logged in, navigate to the applications page and click on Pabbly Connect. Here, you will find the option to create a new workflow. Click on the ‘Create Workflow’ button located in the top right corner of the screen. Name your workflow as ‘Create Shopify Blogs from Google Sheets’ and click on the create button to proceed.

Trigger Setup in Google Sheets Using Pabbly Connect

In this section, we will set up the trigger in Pabbly Connect using Google Sheets. Select Google Sheets as your trigger application. The trigger event you need to choose is ‘New or Updated Spreadsheet Row.’ This means that the workflow will activate whenever a new row is added or an existing row is updated in your Google Sheets.

After selecting the trigger event, a webhook URL will be generated. This URL is crucial for connecting Google Sheets with Pabbly Connect. To do this, go to your Google Sheets, click on Extensions, and then select Pabbly Connect Webhooks. If you do not have the extension installed, search for it in the Add-ons section and install it. Once installed, go back to Extensions, find Pabbly Connect Webhooks, and click on ‘Initial Setup.’ Here, paste the webhook URL you copied from Pabbly Connect.

• Select the trigger column, which is the final data column (e.g., column C).
• Click on Submit to save the configuration.

After successfully configuring the setup, close the dialog box. Now, go back to Extensions, navigate to Pabbly Connect Webhooks, and click on ‘Send on Event.’ This will ensure that whenever a new row is added, the data will be captured by Pabbly Connect.

Configuring Shopify Integration in Pabbly Connect

Next, we will configure the action application as Shopify in Pabbly Connect. In the action window, select Shopify and choose the action event as ‘Create Blog Entry.’ This action will create a new blog post in your Shopify account based on the data captured from Google Sheets.

To establish the connection between Shopify and Pabbly Connect, click on the connect button. If you already have a connection, you can use it; otherwise, create a new connection. You will need your Shopify subdomain and Admin API access token. To get these, go to your Shopify account, navigate to Apps, and create a new app with the necessary permissions.

• Select the ‘Store Content’ permissions for write and read access.
• Install the app and copy the Admin API access token for use in Pabbly Connect.

Once you have entered the subdomain and API token in Pabbly Connect, click on Save. You will now see a list of your existing blogs in Shopify, from where you can select the appropriate blog for the new entry.

Mapping Data from Google Sheets to Shopify

The next step involves mapping the data from Google Sheets to the corresponding fields in Shopify using Pabbly Connect. You will need to fill in the title, author name, and content fields. Mapping allows you to pull the specific data from the previous step, ensuring that the correct information is sent to Shopify.

For example, map the title from the Google Sheets response as ‘Street Style Trends for Summer,’ the author name as ‘Test A,’ and the content from the response. If you have a featured image URL, you can add it in the designated field. Additionally, if you want to use tags, you can specify them here as well.

Set the ‘Publish’ field to true if you want the blog to be published immediately. Click on ‘Save and Send Test Request’ to check if everything is working correctly.

Upon receiving a positive response from Shopify, you will see details like the article ID, title, and author name. This indicates that the integration is successful, and a new blog entry has been created in Shopify.

Verifying the Integration in Shopify

Finally, to verify that the integration between Google Sheets and Shopify is successful, navigate to your Shopify account. Go to Online Store, then Blog Posts, and select the blog you specified during the mapping process. Here, you should see the new blog entry created with the details provided in Google Sheets.

By following the steps outlined in this tutorial, you have successfully set up an automation that allows Pabbly Connect to create a new blog in Shopify whenever a new row is added or updated in Google Sheets. This automation streamlines your blogging process and saves you time.

With Pabbly Connect, you can integrate many more applications, enhancing your workflow and productivity. If you have any questions regarding Pabbly Connect, feel free to reach out for support or visit the Pabbly forum for assistance.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the creation of Shopify blogs from Google Sheets. By following the steps outlined, you can streamline your blogging process efficiently. Automating this workflow not only saves time but also enhances productivity.