.avif)
・
"I'm managing a sales list, but creating individual emails for each contact is exhausting..."
Are you facing this kind of problem? Manually creating emails not only takes time but also tends to lead to mistakes.
Haven't you ever wished you could send emails more smoothly and efficiently?
The solution to this challenge is the integration of Google Sheets and ChatGPT!
Based on the list registered in Google Sheets, ChatGPT can automatically create and send guide emails.
You no longer need to manually create emails one by one.
The setup is surprisingly simple and requires no programming.
You can achieve workflow efficiency with just a few clicks.
Let's utilize Google Sheets and ChatGPT to achieve a smarter workflow!
By using Yoom, you can easily integrate Google Sheets and ChatGPT without any coding.
Yoom provides templates for integrating Google Sheets and ChatGPT, so you can achieve integration immediately without any API knowledge, just by registering.
By integrating Google Sheets with the ChatGPT API, you can automatically connect Google Sheets data to ChatGPT!
For example, you can automatically perform data integration like the one below without human intervention.
This is a convenient flow when you manage sales lists or customer data in Google Sheets and want to send individual guide emails from there.
This flow is recommended for when you want to automatically organize and compile key points separately as survey responses or meeting minutes are continuously added to Google Sheets.
Now, let's actually create a workflow that integrates Google Sheets with ChatGPT!
This time, we'll proceed with the integration of Google Sheets and ChatGPT using Yoom without any coding. If you don't have a Yoom account yet, please create one from the registration form here.
[What is Yoom]
The integration workflow will be created through the following major processes.
First, log in to your Yoom account.
If you haven't used Yoom before, please check out Getting Started with Yoom.
1. Click on My Apps, then click on Add.
2. You can search by app name in the input field.
Let's register Google Sheets with My Apps!
Enter "Google Sheets" in the input field, and the Google Sheets icon will appear. Click on the Google Sheets icon.
1. The following screen will appear.
Click on "Sign in with Google".
2. Select the account to connect.
When you click on the account, you may be asked for additional access similar to Gmail.
Review the content, and if there are no issues, complete the setup.
To execute actions with ChatGPT (OpenAI), you need to subscribe to OpenAI's paid API plan (a state where payment can be made when the API is used).
Using ChatGPT's API is a paid service provided by OpenAI, and it is charged based on the tokens used during API communication.
Therefore, an error will occur if you are not in a situation where payment can be made when using the API, so please be careful.
What you can do by connecting with ChatGPT/OpenAI | Yoom Help Center
Search for ChatGPT in the same way and click on the icon.
1. The following screen will be displayed.
Enter your account name and access token.
For detailed instructions on how to register with My Apps, please refer to the following link.
How to Register ChatGPT with My Apps
If the registration with My Apps is successful, the following screen will be displayed.
Check if the icons for Google Sheets and ChatGPT are displayed on the My Apps screen.
For more detailed information about Yoom, please check the Yoom Help Center.
Click on "Try it" from the link below.
If the following display appears, the template copy was successful.
The copied template will be stored in My Projects.
1. First, click on the icon at the top labeled "When a row is added".
2. Set up the account information to integrate with Google Sheets.
Select "When a row is added" as the trigger. Once the setup is complete, click "Next".
3. Set the Trigger Activation Interval and Spreadsheet ID.
This time, the table range is set as shown in the image below.
In this case, we have prepared the following Google Sheets for testing purposes.
If the test is successful, the information retrieved from Google Sheets will be displayed as output as shown below.
For more details about the output, please refer to the link below.
About the Output
Once the test is successful, don't forget to click "Save"!
1. Return to the flow.
Next, click on the "Generate Text" icon.
2. Set up the account information to integrate with ChatGPT.
Select "Generate Text" as the action.
Once the setup is complete, click "Next".
3. Enter each item.
When creating a message, click the input field to display information retrieved from Google Sheets as shown in the image below, and use it to create your message.
※ Items selected from the output will be displayed as {{〇〇}}.
This indicates that the value is being quoted, allowing you to use the value obtained by the trigger as is.
If you enter fixed text here, it will be generated every time, so be sure to select variable values such as names and phone numbers from the output.
Additionally, settings such as temperature and maximum token count are not mandatory, but if you wish to change them, please refer to the annotations while entering them.
Once the setup is complete, click "Test", and if there are no issues, click "Save".
1. Finally, click on the "Send Email" icon.
2. Set the Email Content.
Click the input field to quote information retrieved from Google Sheets as shown in the screen below.
3. In this flow, we are inserting the response generated by ChatGPT directly into the body as shown in the image below.
How to Set Up "Send Email"
After setting up, click "Next" to preview the email.
With this, the flow of [Automatically Generating and Sending Guide Emails Using ChatGPT from a Google Sheets List] is complete.
Once the setup is complete, the following screen will be displayed.
Click the "Turn on Trigger" button to activate the flow bot.
This was the method for Automatically Generating and Sending Guide Emails Using ChatGPT from a Google Sheets List!
This time, we introduced how to integrate data from Google Sheets into ChatGPT, but if you want to integrate data from ChatGPT into Google Sheets, please also use the template below.
This is a convenient flow for quickly organizing inquiry emails into Google Sheets without leaving them unattended!
This is a recommended flow for situations where you want to categorize the content of an inquiry form into categories such as "Product Questions," "Price Consultations," or "Support Requests," and compile them in Google Sheets!
In addition to integration with ChatGPT, it is possible to automate various tasks using the Google Sheets API. If any of these interest you, please feel free to give them a try!
Additionally, you can register information in other tools when it is added to Google Sheets or send updates of records via email!
Furthermore, you can generate text from content posted in other tools or summarize it and transfer it to a database.
By integrating Google Sheets with ChatGPT, it seems we can significantly reduce the effort required to create emails!
Based on the list registered in Google Sheets, ChatGPT can automatically create and send out informational emails.
This eliminates the need to create emails one by one, improving both the speed and accuracy of operations.
Manual errors can also be prevented, allowing for confident operation.
The setup is easy with no coding required!
By utilizing templates, anyone can quickly build the integration flow.
Why not take this opportunity to combine Google Sheets and ChatGPT to make your operations run more smoothly?
.avif)
.png)
.png)
