thread Re: Use Gemini AI in Google Sheets to fill data easily! in Retail & eCommerce

Use Gemini AI in Google Sheets to fill data easily!

JTPets — Sun, 24 Aug 2025 01:34:36 GMT

I hate gate keepers, here is a tip that is a game changer for me:

This is a simple code you can drop into Google spreadsheets to populate data and give AI context at the same time, in this example I created a few helper rows to isolate cells that were in need of SEO Titles - something I have LONG neglected in my 2700+ item catalog. This allows me to handle hundreds of cells in minutes instead of hours.

The additional helper column to ensure I was only editing the first row of an item with variations was:

=IF(D2="","",COUNTIF(FILTER($D$2:D2,$D$2:D2=D2),D2))

=AI("You are an SEO copywriter for JT Pets, a Hamilton pet store offering natural pet foods, supplies, and free local delivery. Write a short SEO product title under 60 characters. Highlight the product: " & E3 & ". Use this description for context: " & I3 & ". Category: " & J3 & ". Include a benefit (natural, healthy, durable, local, etc.) and mention JT Pets or free delivery if it fits naturally. Output only the title.")

Re: Use Gemini AI in Google Sheets to fill data easily!

dokidoki — Sun, 24 Aug 2025 01:12:02 GMT

How does this spreadsheet get uploaded to Square? Is this the Square Item Library Template?

Re: Use Gemini AI in Google Sheets to fill data easily!

JTPets — Sun, 24 Aug 2025 01:19:30 GMT

Yes, I exported the Square catalog and uploaded the XLSX to google sheets and will download the XLSX after I am done editing

Re: Use Gemini AI in Google Sheets to fill data easily!

_Violet — Wed, 27 Aug 2025 22:18:58 GMT

Thanks for sharing @JTPets ! And not gatekeeping lol

Re: Use Gemini AI in Google Sheets to fill data easily!

yahyalsudani — Fri, 29 Aug 2025 11:10:32 GMT

Please I waited my money almost 2 months. I need them now.

Re: Use Gemini AI in Google Sheets to fill data easily!

JTPets — Fri, 29 Aug 2025 14:44:09 GMT

We can't help on the community forum for account matters you would need to call customer service

Re: Use Gemini AI in Google Sheets to fill data easily!

JTPets — Fri, 29 Aug 2025 14:56:25 GMT

@alexschiff I would love to see this kind of option in the dashboard item set up for my SEO descriptions and SEO Titles

Similar option for Titles I didn't post above, let me set up default variables somewhere and have the dashboard auto populate on item creation with 1 click approval. My data deficit gets smaller every day with AI 🙂

=AI("You are an SEO copywriter for JT Pets, a Hamilton pet store offering natural pet foods, supplies, and free local delivery. Write a concise SEO product description under 160 characters. Highlight the product: " & E3 & ". Use this description for context: " & I3 & ". Category: " & J3 & ". Include a key feature relevant for SEO (examples: grain-free, durable, Canadian-made, high-protein, natural). Mention free local delivery if it fits naturally. Output only the description.")

Re: Use Gemini AI in Google Sheets to fill data easily!

alexschiff — Fri, 29 Aug 2025 15:26:03 GMT

I love this! Super timely as we are just starting to dig into some "bulk actions/updates" ideas for Square AI around catalog. Absolutely will share this with the team and keep the creative examples coming 🙂

Re: Use Gemini AI in Google Sheets to fill data easily!

TammeikoT — Fri, 05 Sep 2025 03:34:19 GMT

I need help

Re: Use Gemini AI in Google Sheets to fill data easily!

JTPets — Fri, 05 Sep 2025 08:25:55 GMT

Care to be more specific

Re: Use Gemini AI in Google Sheets to fill data easily!

cscstore — Mon, 20 Oct 2025 21:20:06 GMT

This is great!
Appreciate you sharing this with the community 🙌

Question regarding this setup:

Could this be used to adjust different Columns?
Example: Rename Items to follow a similar Naming Scheme/Structure
Example: Adjust Parent Categories, and Subcategories

We currently have a large inventory and we would need to adjust all of names to improve SEO and organize our Square for Retail setup.

Any advice or info would be appreciated. Thanks!

Re: Use Gemini AI in Google Sheets to fill data easily!

JTPets — Wed, 22 Oct 2025 16:23:06 GMT

It can be used to update anything you can create context for. Me, i wrote SEO titles and SEO descriptions using name, description and category as "context" for the AI

Re: Use Gemini AI in Google Sheets to fill data easily!

Bronze_Palms — Thu, 23 Oct 2025 19:53:03 GMT

WOW this is amazing!! What other ways do you leverage AI?