Ecommerce product generation automation using Google sheets and Open AI

My goal is to use google sheet with all the data of my ecommerce products. I need AI to generate product descriptions from that data. I know that the step before AI can generate content should involve writing a script in JSON.

My first row of google sheet has attribute name and and all the others bellow are the values, for example A1 = “Code”, A2 = “12348”, A3 = “12548”, A4 = “45846” and so on (A2 row is one product, A3 row is another product, and so on). I need AI to read each row and insert generated description in the first column of the row for each product. Do I need to write a JSON script for that and how it should look like? Also, which options should I choose for the last step of the automation where I chose “Google sheets - Update a row” so that it would embed a generated description for each row of each product?

Welcome to the Make community!

You should be able to simply do something like this:

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like

Hi, thank you for your response. I’ve tried that and it only added one description to the first cell, also the description didn’t have the data from the data provided in the row, it just regenerated an example description provided in a prompt. I thought that I need to specify somehow that it would loop through all the data and insert descriptions in the correct cells.

For further assistance, please provide the following:

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.


Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)


If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    input/output bundle content goes here

  • Or use the format code button in the editor:

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

1 Like