What happened
Google said on Oct 28 that Fill with Gemini in Google Sheets now shows the web sources it used right in each cell. It can also fill up to 3,000 cells in one go. It is rolling out on some paid Workspace and Google AI plans.
Source: Google Workspace Updates, 2026-10-28. This is our short summary. Read the source for the full story.
How a contractor could use it
Make a sheet of suppliers, rental yards or dump sites near you. Let Gemini fill in hours, address and what they carry. Then click the source in each cell and check it before you call or send a crew.
Added 2026-10-29. Check any tool's price and terms on its own site before you use it.
Try this prompt
Copy it into Grok Bot, Claude or ChatGPT. Fill in the parts in [brackets].
For each business name in column A, fill in its street address, phone number, open hours and the main things it sells. They are all near [city, state]. If you can not find something, write Not found. Do not guess.
Want it set up for you? We can do it.
More Office ideas.
-
Idea for contractors
Build a job budget dashboard in Claude or ChatGPT with ProNovos
ProNovos said on Oct 30 that you can now hook Claude or ChatGPT up to your ProNovos account. You ask about your jobs and money in plain words, and it builds dashboards, trackers and what-if views from your live numbers.
View prompt
Show me every active job with billed to date next to budget. Flag any job over 90% of budget. For each flagged job, add one short note on what to check first. Do not change any data.
-
Idea for contractors
Make a job checklist file right in the Gemini app
Google said on Oct 29 that the Gemini app can now make files right in the chat. You can see a PDF, doc, sheet or slide deck, fix it by typing or by asking Gemini, then open it in Google Docs, Sheets or Slides or save it. It is for all Gemini app users. PDFs work on the phone too. Other files work on the web.
View prompt
Make a one page PDF checklist for starting a [job type] job. Sections: before we leave the shop, when we get there, before work starts, and before we leave for the day. Short lines with check boxes. Leave space at the top for the job name, address and date.
-
Idea for contractors
Ask ChatGPT about your iCloud email and calendar
ChatGPT said on Oct 27 that iCloud Mail and Calendar plugins are now in ChatGPT. You can ask it to find an email, catch up on your inbox, check what is next, or update an event. It works on all ChatGPT plans on web, desktop and iPhone.
View prompt
Look at my iCloud calendar for tomorrow. List each job with the time, customer name and address, in order. Then look in my iCloud Mail for any new emails from those customers in the last 3 days and give me a one line summary of each. Do not send, change or delete anything.