Claude with Google Workspace: Two Ways to End Copy-Paste

The copy-paste habit is the thing I see most often when someone first tries Claude with Google Workspace. They open Gmail, select the whole thread, paste it into a chat window, paste it again with the next thread, and by the fourth one they have given up and gone back to reading by hand. It is not that the AI was no help. It is that feeding it the material cost more than the answer saved.

The same thing happens with a Google Sheet. Somebody exports it to CSV, opens the CSV, copies two hundred rows into a prompt, and then watches the formatting fall apart on the way in. Dates become text. The header row gets treated as data. The answer that comes back is confidently wrong, and now you do not trust the tool.

Both problems have the same fix, and it takes about two minutes to set up once. Here are the two things I show in class that change how the day actually goes.

Connect Claude with Google Workspace, Then Stop Pasting Mail

In Claude, open Settings and look for Connectors. Google Workspace is in that list: Gmail, Calendar, and Drive each get their own toggle. Turn them on, sign in with the Google account you actually use for work, and approve the permissions screen Google shows you. That is the whole setup. You do it one time.

From then on you stop pasting and start describing. The wording that works is specific about which mail and what you want out of it:

• Find the thread with the procurement team at Northside from the last two weeks. List every commitment either side made, with who said it and the date.
• Search my mail for anything from this month where someone asked me for a document I have not sent yet. Put it in a table: who, what they asked for, and the date they asked.
• Read the last three messages on the Harrison thread and draft a reply that answers the pricing question and nothing else. Keep it under 120 words.

What comes back is built from the real messages, with the subject lines named, so you can check it. That is the part that beats the manual way: you are not re-reading thirty-one messages to find the one sentence that matters, and you are not trusting a summary you cannot trace.

The gotcha: Claude searches your mail the way Gmail’s own search box does, so a vague request gets vague results. “Find the email about the budget” will pull in six months of noise. Give it a name, a company, or a date range every single time. And it reads mail; it does not send mail on its own — the draft lands in front of you and you are the one who presses send, which is exactly where that decision belongs.

Point Claude at the Sheet Instead of Pasting the Rows

With the Drive connector on, the same trick works for a Google Sheet, and this is the one that surprises people in class. You do not export anything. You name the file.

Try it in this shape:

• Open the Google Sheet called Q3 Regional Sales. Use the tab named Detail. Total revenue by region and by month, and tell me which region fell the most from July to September.
• In the Sheet called Member Renewals, find every row where the renewal date has passed and the status is still blank. List them with the account name and the days overdue.
• Look at the Sheet called Expense Log, tab 2026. Find rows that look like duplicates — same vendor, same amount, dates within three days — and show them side by side.

That last one is worth sitting with. Finding near-duplicates in Excel is a helper column, a COUNTIFS, and a sort, and most people build it wrong the first time. Here it is one sentence, and because the file is read live, you can fix a row in the Sheet, ask again, and get the updated answer without re-sending anything.

The gotcha: name the file and the tab exactly as they appear in Drive. “The sales sheet” is not a file name, and if two files have similar names you will get the wrong one. Also keep your headers in row 1 with nothing above them — a merged title row across the top is the single most common reason the numbers come back shifted by one column.

Plenty more on the calendar

If you want to watch this done live rather than read about it, Claude with Google runs on Tuesday, November 10, and it covers exactly this ground: wiring the connectors up, the prompt wording that gets reliable answers out of Gmail and Drive, and what to do when a connection stops working. Bring a messy Sheet of your own if you have one.

The full current schedule is on the front page of PCWebinars.com, with new dates going up as they are confirmed. Register for this one, or have a look through the others — there is usually something on Excel, Power BI, Copilot, or Claude within the next week or two.

About your trainer

I’m Tom Fragale. I’ve been a computer trainer and consultant for more than 30 years, and I’ve taught well over 30,000 people how to get more out of the software they already own — Excel, Access, Power BI, Word, Outlook, and now the AI tools that sit on top of all of it: Claude, ChatGPT, and Microsoft Copilot. My background is applied, not theoretical. Alongside teaching, I build real databases and reporting systems for clients in Excel, Access, and Power BI, so the examples I use in class are the problems I ran into last week, not textbook exercises. I also publish free tutorials on YouTube and longer courses online.

Everything I teach, along with the current list of live sessions, is at PCWebinars.com.