How to Automatically Generate Product Descriptions Using Anthropic (Claude) Based on Product Information Registered in Google Sheets

Step 1: Connect Google Sheets and Anthropic (Claude) to My App

‍
First, connect Google Sheets and Anthropic (Claude) to Yoom's My App.
This will enable integration such as retrieving product information from Google Sheets and generating product descriptions using Anthropic (Claude).

First, log in to Yoom, and click "+ New Connection" from "My App" in the left menu.

Then, a screen called "New App Connection" will appear, displaying various apps.
On this screen, search for Google Sheets and Anthropic (Claude) and add each one.

When adding Google Sheets, allow all access permissions to Google Sheets during authentication.

Adding Anthropic (Claude) requires an API key. Please issue it in advance from this site.
Once each app is connected, proceed to flow settings.

Step 2: Set the Trigger

The initial setting is "When a row is added".
Click here and check if it is linked with the correct account.

If linked with another account, select the correct account from the "Account information linked with Google Sheets" candidates.
Note that the title can be changed to any text. Proceed with the settings without changing the trigger action by pressing "Next".

Next, specify the trigger activation interval with Google Sheets and retrieve product information.
Set the activation time, and select and enter the spreadsheet ID and sheet ID.
The trigger activation interval can be selected from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
Please note that the shortest activation interval varies depending on the plan.

Select a "column with unique values" that ensures no duplicate values within the same column.
In this case, since Google Sheets is set as shown below, "Product Name" is used as the unique value.

Once the item input is complete, click "Test" to obtain the output.
This retrieves the contents of Google Sheets.

Finally, check the items and click "Save" to complete the trigger settings.

Step 3: Set Text Generation with Anthropic (Claude)

Set an action to generate product descriptions from the retrieved product information using Anthropic (Claude).
In the initial settings, as with Google Sheets, make appropriate title corrections and check if the correct account is selected.

Keep the action as "Generate Text" and press "Next" to proceed.

Finally, confirm each setting in the "API Connection Settings" to complete the Anthropic (Claude) settings.

Step 4: Update Generated Product Descriptions in the Spreadsheet

Set an action to automatically update the generated product descriptions in Google Sheets.
First, as before, verify the account and spreadsheet ID.

Additionally, you can specify the sheet tab where the record update will occur at the bottom of the same page.

If you want to update the product descriptions within the same sheet in Google Sheets, select the same one; if you want to consolidate only the generated product descriptions into a different sheet, specify a different sheet.
Once each setting is complete, click "Next" to confirm the connection.

Once the connection is confirmed, click "Next" and set the conditions for updating the records.

In this function, records are updated in rows that match "① Conditions for the record you want to update" with "② Values of the record after update".
In the above image, it instructs to "Generate Text" in the "Product Description" row of Google Sheets.

Once the settings are complete, click "Test" to verify if the product descriptions generated by Anthropic (Claude) are reflected in Google Sheets.
If successfully reflected, all settings are complete.

Finally, turn on the trigger to activate the flow.

Now, when information is updated on Google Sheets, the product descriptions will be automatically reflected.
Please copy and try the template below.

Other Automation Examples Using Google Sheets

We introduce automation examples using Google Sheets that can be applied to other tasks such as document creation and speedy information sharing.

1. Automatic Quotation Issuance!

By linking kintone's status update information with Google Sheets, you can automatically issue quotations.
The automatically issued quotations are sent via Gmail after manual approval, leading to improved work efficiency.

2. Automatically Convert CSV Files!

You can automate the process of converting CSV files received via email into spreadsheets and accumulating the file information.
By automating this series of operations, you can not only save time but also prevent human errors.

3. Streamline Information Sharing!

When the information in a Google Spreadsheet is updated, you can automatically receive notifications on LINE.
This is recommended for teams working collaboratively on Google Spreadsheets or companies that frequently use LINE for business communication.

Summary

The automatic generation of product descriptions using Google Sheets and Anthropic (Claude) seems to improve work efficiency while reducing variations in writing style.
It can be easily set up with no-code and can be introduced immediately without any specialized knowledge.

By using this system, why not streamline and standardize the creation of product descriptions that used to be cumbersome?
If you are interested, please consider registering for Yoom for free.