How to Write Emails from Subject Line Using Pabbly Connect and Writesonic

Learn how to automate email writing from subject lines in Google Sheets using Pabbly Connect and Writesonic. Follow this step-by-step tutorial for seamless integration. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin the process of writing emails from subject lines, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website at Pabbly.com/connect. Here, you will find options to sign in or sign up for free, which takes less than two minutes.

If you are a new user, create an account to receive 100 free tasks. Once logged in, navigate to the Pabbly Connect dashboard where you can create a new workflow. This is where the integration between Google Sheets and Writesonic will be set up.

2. Creating a Workflow in Pabbly Connect

Now that you are in Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. A suitable name could be ‘Write Emails from Subject Line Using Writesonic’. This identifies the purpose of your workflow clearly.

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

This URL acts as a bridge between Google Sheets and Writesonic, allowing real-time updates whenever a new subject line is added.

3. Setting Up Google Sheets for Integration

Next, you need to set up Google Sheets to work with Pabbly Connect. Create a new spreadsheet named ‘Subject Lines for Writesonic’ and include columns for subject lines and email content. This will help in organizing your data efficiently.

Go to ‘Extensions’ in Google Sheets, select ‘Add-ons’, and then ‘Get Add-ons’. Search for and install the Pabbly Connect Webhooks add-on. After installation, refresh the Google Sheets page to ensure the add-on is active.

• Open the Pabbly Connect Webhooks add-on and navigate to ‘Initial Setup’.
• Paste the copied webhook URL into the designated field.
• Set the trigger column to the column where the subject line is entered (e.g., Column A).

Click on ‘Send Test’ to ensure the setup is correct. This step confirms that Google Sheets is properly linked to Pabbly Connect.

4. Using Writesonic to Generate Emails

With the Google Sheets setup complete, the next step is to use Pabbly Connect to integrate with Writesonic. Select Writesonic as your action application in the workflow. The action event should be set to ‘Chat Sonic’. This allows you to generate email content based on the subject line.

When prompted, connect your Writesonic account by entering your API key. To obtain the API key, log into your Writesonic account, navigate to the API dashboard, and activate the API key. Once you have it, paste it into Pabbly Connect to establish the connection.

Map the input text by writing ‘Write an email with the subject’ followed by the subject line from Google Sheets. Disable Google results if prompted, and click on ‘Save and Send Test Request’.

This step will generate an email based on the subject line, which is then ready to be updated back in Google Sheets.

5. Updating Google Sheets with Email Content

Finally, the last action in your Pabbly Connect workflow is to update the Google Sheets with the generated email content. Select Google Sheets again as the action application and set the event to ‘Update Cell Value’. This ensures that the generated email is stored in the correct cell.

Connect to your Google Sheets account again, select the spreadsheet you created earlier, and specify the correct column (e.g., Column B) where the email content will be updated. Map the row index from the previous steps to ensure the data is placed correctly.

Click ‘Save and Send Test Request’ to confirm the update. Check Google Sheets to verify that the email content appears in the designated cell.

With this, your integration is complete! Now, every time you add a new subject line in Google Sheets, an email will be automatically generated and updated in the spreadsheet using Pabbly Connect.

Conclusion

This tutorial has provided a detailed guide on how to automate the process of writing emails from subject lines using Pabbly Connect and Writesonic. By following these steps, you can streamline your email writing process efficiently. Enjoy the benefits of automation!