We will explore how to use Writesonic along with Google Sheets to create effective marketing emails. Once the integration is in place, all you need to do is add the email subject in a new row of your Google Sheets spreadsheet, and Writesonic will generate a marketing email based on that subject automatically.
This automation requires a one-time setup, for which we will use Pabbly Connect.
Firstly, we will link Google Sheets to Pabbly Connect to capture the email subject. Then, we will link Pabbly Connect with Writesonic to compose the marketing email. Finally, we will link Pabbly Connect with Google Sheets once again to store the generated email in the Google Sheets spreadsheet.
Steps to Automatically Write Marketing Emails using Writesonic
1. Sign In / Sign Up to Pabbly Connect and Create a Workflow
2. Setup Google Sheets as the Action App to Capture Email Subject
3. Setup Writesonic as the Action App to Compose Emails
4. Setup Google Sheets as the Action App to Store Emails
Step 1:- Sign In / Sign Up to Pabbly Connect and Create a Workflow
A. Sign In / Sign Up
To begin this process, visit Pabbly Connect and create your account by clicking on the ‘Sign Up Free’ button. You can also click on Sign In if you already have an account.
Click on the Pabbly Connect ‘Access Now’ button
B. Create Workflow
To create a new workflow, click the ‘Create Workflow’ button.
Name your workflow, and click on ‘Create’.
Step 2:- Setup Google Sheets as the Action App to Capture Email Subject
Now, we will go over the steps needed to establish a connection between Google Sheets and Pabbly Connect, enabling us to retrieve data from Google Sheets.
A. Trigger App
Trigger allows us to choose the application that will receive the data for Pabbly Connect. In our case, it would be Google Sheets.
Choose ‘Google Sheets’ as the Trigger App and select ‘New or Updated Spreadsheet Row’ as a Trigger Event.
B. Webhook URL
A new Webhook URL will be generated for you. You will utilize this URL to establish a connection between your Google Sheets account and Pabbly Connect. Copy the Webhook URL.
After copying the Webhook URL, Pabbly Connect will start searching for data in your Google Sheets account, as indicated by the rotating Waiting for Webhook Response button.
C. Connect Google Sheets Account
To connect with your Google Sheets account, open the spreadsheet where you wish to input the data, click on Extensions > Add-ons > Get add-ons, and search for ‘Pabbly Connect Webhook’.
After installing the add-on, again click on Extension > Pabbly Connect Webhooks > Initial Setup.
Paste the Webhook URL that we copied earlier, and in the Trigger Column, mention the name of the last column in which the data is available, and click on ‘Send Test’.
Now that the data is sent successfully – click on ‘Submit’.
Now, click on Extension > Pabbly Connect Webhooks > ‘Send On Event’.
Expand Response Received section to verify that the captured data from Google Sheets is visible, thus confirming the established connection.
A connection has been established between Google Sheets and Pabbly Connect, allowing for the automatic capture of any email subjects entered into your Google Sheets spreadsheet.
Step 3:- Setup Writesonic as the Action App to Compose Emails
Action allows us to choose the application that will get executed by the workflow trigger.
Our main goal is to compose marketing emails based on the captured email subjects from Google Sheets using Writesonic. Thus, Writesonic will be our Action App.
A. Action App
Choose ‘Writesonic’ as the Action App, select ‘ChatSonic (Like ChatGPT) as your Action Event, and click on ‘Connect’.
B. Connect Writesonic Account
To connect with your Writesonic account, select ‘Add New Connection’, find and enter your API Key, and click ‘Save’.
In Input Text, give a prompt by mapping the subject of your email from the step above.
Enable Google Results if you want to, and then click on ‘Save & Send Test Request’.
When you click on Save & Send Test Request, a marketing email will automatically be composed.
Step 4:- Setup Google Sheets as the Action App to Store Emails
After creating the marketing email, our next step is to save it into our Google Sheets spreadsheet. It can either be the same spreadsheet that you are already using to capture the subject or a new one altogether.Regardless of the scenario, we will need to configure Google Sheets as our Action App.
A. Action App
Choose ‘Google Sheets’ as the Action App, select ‘Update Cell Value’ as the Action Event, and click on ‘Connect’.
B. Connect Google Account
To connect with your Google Sheets account, select ‘Add New Connection’ and click on ‘Connect with Google Sheets’. Additionally, give permission for authorization.
Specify the cell Range where you intend to store your email.
In Value, map the composed email from the previous step, and click on ‘Save & Send Test Request’.
Once you click on Save & Send Test Request, the email will be stored in your Google Sheets spreadsheet.
Our automation is complete. We have successfully integrated Writesonic with Google Sheets. As a result, whenever you enter an email subject in your Google Sheets spreadsheet, an email on the same subject will be automatically created, and a copy of that email will also be saved in your Google Sheets spreadsheet.
You can copy this entire workflow by clicking this link.
Sign Up for a free Pabbly Connect account, and start automating your business
Subscribe to our Youtube Channel for more such automation
For any other queries, visit our forum