Automate Marketing Emails with Pabbly Connect, Google Sheets, and Open Router

Learn how to automate marketing emails using Pabbly Connect, Google Sheets, and Open Router in this detailed tutorial. Follow step-by-step instructions for seamless integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Email Automation

To start automating marketing emails, we will use Pabbly Connect. First, access the Pabbly Connect homepage by typing Pabbly.com/connect in your browser. Here, you can either sign in if you are an existing user or sign up for free to create a new account.

Once you sign up, you will receive 100 free tasks each month to explore the features of Pabbly Connect. After logging in, navigate to the dashboard where you can manage your workflows and integrations.

2. Creating a New Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the ‘Create Workflow’ button located in the upper right corner. A dialog box will appear prompting you to name your workflow. You can name it something descriptive, like ‘Automatically Generate Marketing Emails with Open Router.’ Choose a folder to save your workflow.

Once you click ‘Create’, you will see two sections: Trigger and Action. The trigger indicates what event starts the workflow, while the action defines what happens once the trigger occurs. For this integration, we will select Google Sheets as our trigger application.

• Select Google Sheets as the trigger application.
• Choose the trigger event as ‘New or Updated Spreadsheet Row’.
• Copy the webhook URL provided by Pabbly Connect for the next steps.

With these steps, you have successfully set the trigger for your automation using Pabbly Connect.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets with Pabbly Connect, open your Google Sheets document where you want to automate the email generation. You will need to install the Pabbly Connect webhooks add-on if you haven’t done so already. Go to Extensions > Add-ons > Get Add-ons and search for ‘Pabbly Connect Webhooks’ to install it.

After installation, refresh your Google Sheet. Navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL you copied earlier from Pabbly Connect. Specify the trigger column, which in this case is Column A, where you will input the titles for which emails will be generated.

• Paste the webhook URL in the designated field.
• Set the trigger column to ‘A’ for title inputs.
• Click ‘Send Test’ to verify the connection.

Once the test is successful, your Google Sheets is now connected to Pabbly Connect, allowing it to capture data automatically.

4. Generating Marketing Emails Using Open Router

With the Google Sheets connected to Pabbly Connect, the next step is to set up the action to generate marketing emails using Open Router. In the Action section of your workflow, select Open Router as the action application. Choose the action event as ‘Create Chat Completions’.

To connect Open Router, you will need an API token. Retrieve this from your Open Router account under the key section. After entering the API token in Pabbly Connect, fill in the required fields to generate the email content.

Enter the HTTP referral (AI site URL). Select the model as ‘Open AI GPT 3.5 Turbo’. Map the title from the Google Sheet to the content instruction.

After filling all details, click ‘Save’ to generate a marketing email based on the title entered in Google Sheets. This automation allows for dynamic email generation without manual input.

5. Updating Google Sheets with Generated Emails

After generating the email, the final step is to update the Google Sheet with the newly created email content. In Pabbly Connect, add another action step and select Google Sheets again. This time, choose the action event as ‘Update Cell Value’.

Connect to Google Sheets using your existing connection. Specify the spreadsheet name and the range where the email should be updated. For this, use Column B and map the row index from the previous response to ensure it updates the correct cell.

Set the spreadsheet name as ‘Marketing Emails’. Input ‘B’ for the column where emails will be updated. Map the row index for dynamic updates.

Once you click ‘Save’ and send a test request, the email will be automatically added next to the corresponding title in Google Sheets, completing the automation process.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the generation of marketing emails from titles entered in Google Sheets. By integrating Open Router with Google Sheets through Pabbly Connect, you can streamline your email marketing process efficiently.