Automatically Create & Schedule Blogs in Shopify using Google Gemini with Pabbly Connect

Learn how to automate blog creation and scheduling in Shopify using Google Gemini and Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To automate the creation and scheduling of blogs in Shopify using Google Gemini, first, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website and signing in to your account. If you are new, you can sign up for free and enjoy 100 free tasks every month.

Once logged in, you will see the dashboard of Pabbly Connect. Here, click on the option to create a new workflow. This is where you will set up the automation that links Google Gemini and Shopify through Google Sheets.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, once you click on ‘Create Workflow’, a dialog box will prompt you to name your workflow. Name it something descriptive, like ‘Automatically Create and Schedule Blogs in Shopify using Google Gemini’. Then, select the appropriate folder for organization.

• Name your workflow clearly for easy identification.
• Choose a folder where the workflow will be saved.

Click ‘Create’ to finalize your workflow setup. Now, you will see two main sections: Trigger and Action. The Trigger defines what starts the workflow, while Action determines what happens as a result.

3. Setting Up the Trigger in Pabbly Connect

For this automation, we need to set up a trigger in Pabbly Connect. Click on the trigger application and select ‘Schedule by Pabbly’. This allows you to run the workflow daily, checking for blog titles to be published.

Set the trigger event to ‘Schedule Workflow’, and specify that you want this workflow to run every day at 12:00 PM. This ensures that your blog titles from Google Sheets will be checked daily for publishing on Shopify.

• Select ‘Schedule by Pabbly’ as the trigger application.
• Set the trigger event to ‘Schedule Workflow’.
• Choose the time for the workflow to run daily.

After saving the trigger settings, your workflow is now configured to check for blog titles based on the current date.

4. Action Steps for Blog Content Generation

Next, we need to set up the action steps in Pabbly Connect. The first action is to retrieve the current date using the ‘Date/Time Formatter’ by Pabbly. This is essential for comparing against the dates listed in your Google Sheets.

Once you have the current date, the next action is to look up the relevant blog titles in Google Sheets. Use the ‘Google Sheets’ application and select ‘Lookup Spreadsheet Rows V2’ as the action event. Connect your Google Sheets account to Pabbly Connect and choose the spreadsheet that contains your blog titles and publishing dates.

Use ‘Date/Time Formatter’ to get the current date. Select ‘Lookup Spreadsheet Rows V2’ in Google Sheets. Map the current date to look up blog titles.

After mapping the data, you can process the results to generate blog content using Google Gemini.

5. Generating Blog Content and Publishing to Shopify

Now that we have the blog titles, we can generate content using Google Gemini. In Pabbly Connect, add an action step for Google Gemini and select ‘Generate Content’ as the action event. Connect your Google Gemini account by providing the required API key.

Map the title from the previous step as the prompt for content generation. Once the content is generated, add another action to publish the blog in Shopify by selecting ‘Create Blog Entry’. Connect your Shopify account and map the necessary fields such as blog title, content, and author.

Select ‘Generate Content’ in Google Gemini for the content creation step. Map the title to generate relevant blog content. Use ‘Create Blog Entry’ in Shopify to publish the blog.

After reviewing the generated content, you can choose whether to publish it immediately or keep it as a draft for later review.

Conclusion

By following this tutorial, you can effectively automate the creation and scheduling of blogs in Shopify using Google Gemini and Pabbly Connect. This integration streamlines your blogging process, enhancing customer engagement with minimal manual effort.