About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I automate ChatGPT for Google Sheets image-based title, summary generation, and multi-row update with Zapier?
Best answer

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

  • 19 February 2024
  • 6 replies
  • 37 views
M

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. 

 

 

 

icon

Best answer by Troy Tessalone 19 February 2024, 21:42

View original

6 replies

Troy Tessalone
Userlevel 7
Badge +14

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

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!

 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@midorimiab 

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

 

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

Thanks! 
Worked great :)

ken.a
Userlevel 7
Badge +6

That’s awesome @midorimiab! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Y

Hello 

how does one create a qr code using chagpt and google sheet

Reply


Terms & Conditions