Best answer

How do I automate ChatGPT for Google Sheets image-based title, summary generation, and multi-row update with Zapier?

1 year ago
February 19, 2024
6 replies
63 views

midorimiab
10 replies

Hi,

Im new to Zapier and assume there is a simple answer to my question.

I have a GoogleSheet containing all items in my e-commerce. After that I have taken the product picture I place it in Google Drive and place the link into the correct row GoogleSheet. After this I would like ChatGPT to write a short title and summary based on the image and update two columns in the sheet.

It works as planned, but just for the first row. I assume that I have made some basic mistake in the set-up, but I can not find int.

Best answer by Troy Tessalone

@midorimiab

You need to map the Row variable or ID variable from Step 1.

View original

Did this topic help you find an answer to your question?

+14

Troy Tessalone
Zapier Expert
31050 replies
1 year ago
February 19, 2024

Hi @midorimiab

For us to have full context, we would need to see screenshots with how each Zap step is configured.

Step 5 should have the Row/ID mapped from Step 1.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

M

midorimiab
Author
10 replies
1 year ago
February 19, 2024

HI Troy,

Sure, please find attached.

I do belive it has to do something with my triggers. The row I am chosig is also the one that works fine, all the others generats an error “invalid image”. So for the example below it works fine in row 996, byt not on the others.

Thanks!