Showing posts with label Quick Wins. Show all posts
Showing posts with label Quick Wins. Show all posts

18.11.26

Gemini Skills for VAs: Set Client Rules Once


A virtual assistant holding a blank recipe card next to a card box and a laptop

How many times this week did you type "keep it short, sign off as Dana, never promise a delivery date" into Gemini for the same client? Gemini skills are Google's fix for that. You write a client's rules once, save them, and Gemini applies them in Gmail, Docs, Slides, Drive and Chat.

Google started rolling skills out across Workspace apps in November. Here's what they are, who gets them and when, and how I'd set them up for each client.

What Gemini skills are

Google describes skills as reusable, custom instructions that guide Gemini to apply your team's rules, templates and reference files. Think of a recipe card. You write it once, file it, and pull it out whenever you cook that dish.

For a VA, one skill could hold a client's email voice. Another could hold their proposal format. A skill can also point to reference files in Google Drive, like a price list or an FAQ doc, so Gemini works from the client's real information.

Once a skill is turned on, Gemini can spot when it's relevant and apply it on its own. You can also call one up by typing @ and its name, and you can combine more than one in a single request. So you could type something like "@ClientA-email-voice @ClientA-FAQ, reply to this customer."

Gemini skills rollout: dates and plans

Skills live in two separate places, and people mix them up.

Skills in Google Workspace are the ones inside Gmail, Docs, Slides, Drive and Chat. Google's Workspace Updates blog says these started a gradual rollout on November 9 for Rapid Release domains, and start on November 30 for Scheduled Release domains. Each rollout can take up to 15 days before the feature shows up.

Rapid Release and Scheduled Release are settings the account admin picks. Rapid gets new features first, and Scheduled gets them at least a week later. For skills, the gap is three weeks. If your client's account doesn't show skills yet, ask whoever runs their Google admin which one they're on.

Workspace skills come with Business Starter, Standard and Plus, Enterprise Starter, Standard and Plus, and two add-ons: Google AI Pro for Education and AI Expanded Access. They're for users 18 and older, and they're on by default unless an admin switches them off.

Skills in the Gemini app are the other place. Those started rolling out on October 13 and are available to all Workspace customers and to personal Google accounts. The two don't sync, so a skill you make in one won't appear in the other.


Google's Workspace Updates post announcing skills in Google Workspace

How to make one

Google gives you three ways to create a Workspace skill. You can build it in Google Workspace Studio, Google's tool for creating skills and automated flows. You can draft it in Google Docs with Skill Builder. Or you can ask Gemini to make one right inside Gmail, Docs, Slides, Drive or Chat.

Creating, editing and sharing happen on the web. You can use skills on the web and in the Google Chat mobile app.

Workspace skills aren't in Google Sheets or Google Meet yet, and they only take English prompts and instructions for now. When you share a skill from Workspace Studio, the other person gets their own copy, so later edits you make won't change theirs. If your skill points to Drive files, you have to share those files separately.

What happens to Gems

Gems were Google's earlier way to save custom instructions, and skills are replacing them.

According to Google's September announcement, Gems move to the Settings panel of the Gemini app on November 17, and you can keep using them for now. For business and enterprise accounts, no sooner than March 1, 2027, Gems can no longer be created, edited or used. Any left in the Gemini app become draft skills in the Gemini app at that point.

That automatic move doesn't reach Workspace. A Gem won't turn into a skill in Gmail or Docs on its own. If you want it there, you rebuild it. Skills use an open text format called SKILL.md in both places, so you can copy the instructions across by hand.

Workspace Studio also no longer lets you add new "Ask a Gem" steps to flows. Existing ones keep working until Gems switch off in 2027.

What This Means for VAs

If you work inside a client's Google Workspace account, their plan decides what you get. Check two things before you promise anything: which plan they're on, and whether their admin has skills switched on.

Then build one skill per client, starting with the thing you repeat most, usually email voice. Keep it short and specific: sign-off, tone, words to avoid, who gets copied, what you never promise. Point it to one Drive doc with their FAQs or prices.

If you already have Gems for clients, make a list now. Rebuild the important ones as Workspace skills before the 2027 cut-off, since the automatic move only happens inside the Gemini app.

One more habit worth keeping: tell the client you've saved their rules as a skill, and show them what's in it. It's their account, so it's their rulebook too. If they want the same rules in their own Gemini, you can share them a copy from Workspace Studio.

[MAYE (optional): a screenshot of one client email-voice skill you've set up, with names blurred.]

Not sure what rules to collect from a client in the first place? My free VA client onboarding questionnaire asks for most of them.

9.11.26

Zapier for Beginners 2026: Free Courses + 5 VA Zaps


A virtual assistant at a laptop with app icons linked by dotted arrows

Zapier for beginners in 2026 comes down to two free things: Zapier's own Academy courses, which come with certificates, and the free plan, which is enough for your first automations. Here's what each course covers, the honest answer to "is there a Zapier certification?", and five simple Zaps a VA can build this week.

First, the words. Zapier connects apps so work moves between them without you copying and pasting. A Zap is one of those automated workflows: a trigger (the thing that starts it, like a new email) and an action (what Zapier does next, like saving the attachment).

Why VAs Should Learn It

Clients ask for it. VA Masters looked at 322 VA job descriptions from February to August 2026. Zapier appeared in 5.6% of roles, and Zapier and n8n together showed up in more roles than ChatGPT did on its own (7.5%).

That's an agency's own data, but their conclusion is a good one for us. Clients aren't only hiring someone who can write a prompt. They want someone who can wire a process together.

Zapier for Beginners 2026: The Free Academy Courses

Zapier Academy has four main stages, plus two courses for managers.


Zapier Academy page showing four courses: 01 Chat, 02 Delegate, 03 Automate and 04 Engineer

01 Chat (55 min) is about getting finished work out of ChatGPT, Claude, Copilot or Gemini. It isn't about Zapier yet, so skip it if you already use AI every day.

02 Delegate (about 25 min) connects your AI chat to your apps through Zapier MCP. MCP is a way to let an AI like Claude or ChatGPT read and act inside your other apps, with you deciding how much it may do.

03 Automate (about 35 min) is the one for this post. You describe a repeating job in your AI chat, the AI builds the Zap, and you read it, test it and publish it yourself. Nothing goes live until you say so. Zapier suggests taking 02 Delegate first if you haven't connected an AI to your apps yet.

04 Engineer (about 65 min) is for people who have already built Zaps and want them to hold up for a whole team.

The other two, Admin Essentials (about 60 min) and AI Transformation Leaders (about 2 h 30), are for Enterprise account admins and the people running AI adoption at a company. Most VAs can skip them.

Zapier's FAQ says every course is free and a free Zapier account is enough. Finish a course and you get a certificate of completion with a link to add it to LinkedIn.

Is There a Zapier Certification?

Not one you can sign up for on your own as a learner, as far as Zapier's own pages show. The Academy gives a certificate of completion for each course. That's a nice proof of learning, but it isn't an exam-based certification.

The closest thing is the Zapier Solution Partner Program, which used to be called Zapier Experts. It's for consultants, agencies and solution providers, and partners go through a certification program and earn badges as they go. To apply, Zapier asks for an active business website (a LinkedIn or Fiverr profile alone doesn't count) and an email on your own domain, not Gmail or Outlook. Zapier says applications are typically reviewed within 7 to 21 business days.

So on your profile, be exact: "Zapier Academy, 03 Automate (certificate of completion)". Don't write "Zapier certified" unless you've earned a certification through the partner program.

The Free Plan in One Paragraph

Zapier's pricing page lists the Free plan at $0 with 100 tasks a month, unlimited Zaps and two-step Zaps (one trigger, one action). A task is used each time a Zap successfully completes an action (some actions use more than one), and triggers don't count. Premium apps need a paid plan, so if an app shows a Premium label, pick another. For simple two-step Zaps, a hundred tasks is roughly three runs a day across all of them.

5 First Zaps for VAs

All five are two-step, so they fit the free plan. Build them in your own test account with fake data first, then in a client's account only with their permission.

  1. Invoices to Drive. When a Gmail email with an attachment gets your "Invoices" label, save the attachment to a Google Drive folder.
  2. New form, instant ping. When someone submits your Google Forms intake form, send yourself a Slack direct message.
  3. Meeting log for billing. When a new event is added to Google Calendar, add a row to a Google Sheet with the title, date and time.
  4. Draft, don't send. When a new row is added to your lead or task sheet, create a Gmail draft. You review it and press send yourself.
  5. Starred email to task. When you star an email in Gmail, create a Trello card so it lands on your to-do board.

If you're not sure which trigger to pick, describe the job in plain words to an AI, the way the 03 Automate course teaches, and check what it builds before you turn it on.

What This Means for VAs

Zapier sits between "I can use ChatGPT" and "I can build systems". That middle step is where a lot of admin work lives: the copying, filing and reminding that eats your afternoon.

Take 02 Delegate and 03 Automate, build Zaps #1 and #4, and write down the steps for each one so a client could follow them. That written process is half of what makes an automation trustworthy, and my VA SOP template gives you a place to put it. For other free courses worth adding, see free AI courses for virtual assistants.

Build your first Zap this week, then tell me how it goes in the comments.

4.11.26

How to Turn a Messy Spreadsheet Into a Claude Dashboard


You can upload a messy spreadsheet to Claude, ask it to clean the data, and get back a dashboard with charts you can click through and share, all in one chat. No formulas, no coding, and it works on the free plan, though sharing a link needs a paid plan.

If you've ever been handed a client's "tracker" with merged cells, three date formats and a tab called FINAL_v2, this one's for you. Here's how to get from that sheet to a Claude dashboard, step by step, plus the checks I'd never skip.

To test it, I made a practice sheet that looks like a realtor client's listings research: 312 rows of made-up home listings with duplicates, mixed date styles, misspelled neighbourhoods, missing prices and a stray "average" row in the middle. No real client data went in. I ran everything in a normal Claude chat on my Max plan.

What Claude Can Do With a Spreadsheet

Two Claude features do the work here, and both are in Anthropic's help center.

The first is file creation and analysis. Claude runs code in a safe, closed-off space on Anthropic's side, so it can read the spreadsheet you upload, clean it, and give you back a new Excel file. You can upload CSV, TSV and other data files, up to 30 MB each. Anthropic lists it for every plan: Free, Pro, Max, Team and Enterprise.

The second is artifacts. An artifact is something Claude makes that opens in its own window beside the chat, like a document, a deck, or a dashboard. You can keep editing it and share it. Creating artifacts in a chat is also available on every plan.


One setting to check first. Artifacts and file creation both need the "Code execution and file creation" switch turned on. In newer versions of Settings, it's called "Create and edit files". On Free, Pro and Max, you'll find it under Settings, then Capabilities.

Claude Dashboard Examples: The Step-by-Step

1. Make a safe copy. Before anything touches AI, save a copy of the sheet and strip out what doesn't need to be there: customer names, emails, phone numbers. A dashboard about listings by month doesn't need anyone's personal details.

2. Ask Claude to describe the mess first. Upload the file and ask: "Before you change anything, list every problem you see in this data: duplicates, mixed date formats, blank rows, typos in category names." For my listings sheet, I swapped the last part for "typos in neighbourhood and property type names." This gives you a to-do list you can check, instead of fixes you can't see.

[ADD IMAGE: claude-problem-list.jpg]

Claude found every problem I'd hidden in the sheet: 6 duplicate listings, 5 blank rows, the stray average row, 18 missing prices and 5 prices with an extra zero. It even noticed the sheet mixed "Harbor View" and "Harbour View". Then it asked me three questions before touching anything, like whether "Single Family" should count as "House".

3. Clean it, and keep the receipt. Ask Claude to fix the problems and give you a cleaned Excel file, plus a short note on every change it made. You want the note, because your client will ask why a number moved.

In my test, the cleaned file came back with a change log sheet listing every fix, and the original file stayed untouched. Its average price, $489,704 across 277 listings, matched my own check to the dollar.

4. Ask for the dashboard with real questions. This is the step most people rush. Don't just say "make a chart." Say what the client wants to know. Here's what I asked: "Build an interactive dashboard from the cleaned data that shows new listings by month, the average list price by neighbourhood, the top five neighbourhoods by number of listings, and which neighbourhood's prices dropped since last quarter, with a filter by property type."

Anthropic's own tip for its dashboard feature says the same thing: say what you want to know, not just what to chart.


It took two follow-up messages. First, Claude showed me its plan and waited for my go-ahead before building anything. Then the "change since last quarter" column came out cut off on the right edge, so I asked it to fix that. The dashboard opened in its own window beside the chat, and the property type filter updated every chart on the page.

5. Check the numbers against the sheet. Pick three figures on the dashboard and find them in the original spreadsheet yourself. If the total for March on the dashboard doesn't match a simple sum in Excel, ask Claude to explain how it got there.

Claude told me straight out that it hadn't opened the dashboard to look at it, and asked me to check it over. Good thing I did. Harbor View showed a 29.6% price drop since last quarter, and Claude's summary said to treat that number with care. So I clicked the House filter, and the drop shrank to 10.4%. Harbor View simply had mostly houses listed from April to June, and mostly condos from July to September. If I'd sent the first number to a realtor, it would have looked like prices crashed.


I asked Claude to add one line under the table explaining the difference, and it did, with the numbers to back it up.

6. Share it. Artifacts start private. On Pro and Max, you can switch one to "Anyone with the link" or invite people by email. On Team and Enterprise, your client's admin decides whether links can go outside the company. Check who can see it before you send it, the same way you'd check a Google Drive link.

What About Claude's Dashboards Template?

You might see a "Dashboards" template in the Claude app. It's a different tool. It's in beta on paid plans (Pro, Max, Team and Enterprise), and it's built for data that lives in a company database or in a connected app like Salesforce. Claude writes the queries and each chart shows how it got its number.

For a spreadsheet someone emailed you, the regular chat steps above are what you need. If your client's data already lives in one of those systems, the template is worth a look.

What This Means for VAs

Reporting is one of the most useful things a VA can offer, and one of the most tedious to build by hand. With Claude, the cleaning and charting become a conversation.

But the value isn't the chart. It's that you asked the right questions, removed private data before uploading, and checked the totals before your client saw them. That's what makes a dashboard trustworthy, and it's still your job.

Start with a sheet you already know well, so you can spot a wrong number straight away.

If you build one, tell me what your client said about it.

31.10.26

Arc Is Shutting Down Dec 22: Move Client Workspaces Now


Arc is shutting down on December 22, 2026, and after that the browser stops working on Mac and Windows. If you keep each client in their own Arc Space, you have until then to move everything, and it takes a few clicks if you do it before the deadline.

Here's the Arc browser shutting down timeline, the easiest way to move, and a plain backup plan if you'd rather not use Dia.

Arc Browser Shutting Down: The Dates

The Browser Company, the team behind Arc, announced the shutdown on October 22. Their own farewell page at arc.net lays out three dates.

October 22: nobody can create a new Arc account. Existing accounts keep working, and the latest version of Arc adds an option to export your data.

November 23: on iPhone and Android, Arc Search loses "Browse for Me" and its other AI features. It still works as a basic browser, but you can't sign in or sync tabs anymore.

December 22: Arc stops working on Mac and Windows, and Arc Search for Android is removed from the Google Play Store and from phones. Accounts are deactivated, and Arc says personal data is deleted within 30 days. From that date, Arc says it can no longer retrieve your data for you.


The Easy Move: Arc to Dia

Dia is the newer browser from the same team. It's free, and its AI features are optional. Arc's page says you don't need to export anything first if you're moving to Dia.

If you don't have Dia yet: download it from diabrowser.com, and when it asks which browser to import from, pick Arc. Arc says it brings over your passwords, history, tabs, Profiles, Folders, bookmarks and extensions, on both Mac and Windows.

If you already have Dia: on a Mac, go to Dia > Import from Another Browser in the menu bar. On Windows, open the Dia app menu and choose "Import from another browser."

A few names change on the way. Your Spaces become Profiles, and you can still swipe between them. Folders become Tab Groups. Pinned tabs and Favorites come over with their custom names. If you miss the vertical tabs, choose "Sidebar tabs" in Dia.

One setting to check before you open client work in Dia. Dia's FAQ says that unless you opt out in the Privacy Panel of Dia's settings, your content data is shared to improve Dia (not tied to your profile, and deleted after 30 days). If a client's contract is strict about data, turn that off first.

The Backup Plan: Save Your Tabs as Links

Maybe your client doesn't want a new browser, or you'd rather go back to Chrome. Arc lets you save your Spaces and tabs as a list of links.

On a Mac: open Arc > Settings, go to Advanced, then choose Export Data and save the file. On Windows: press Ctrl+comma to open Settings, find "Export Spaces and tabs" in the Advanced section, and choose Export Data.

Arc's page only covers exporting tabs this way. It doesn't give steps for moving saved passwords into another browser. So before you leave Arc, check that every client login also lives in a password manager, not only in the browser.

If you do land in Chrome, its help pages say Chrome imports bookmarks from an HTML file, and passwords only from a .csv file. Google also warns you to delete that .csv afterward, because anyone using the computer can open it.

What This Means for VAs

If you use Arc for client work, your Spaces might be the whole system: one Space per client, their tools pinned, their logins saved. Losing that in a rush would mean a messy week of password resets and "can you resend that link?"

Here's how I'd handle it. Pick a quiet afternoon this week. Import into Dia, then open each client's Profile and click through their pinned tabs to check you're still logged in. Write down anything that didn't come across. Then export your tabs from Arc anyway, as a backup file.

If you set up Arc for a client, send them a short heads-up with the December 22 date. That two-minute email can save them a lot of panic in December.

Moving browsers this week? Tell me which one you picked.

28.10.26

30 Free Virtual Assistant Prompts for ChatGPT and Claude


Here are 30 free virtual assistant prompts you can paste into ChatGPT or Claude today, sorted by the task in front of you. Every one of them tells the AI to ask before it guesses.

I use prompts like these every day in my own VA work. Search for a list like this and almost everything that comes up is a paid prompt pack. So here's mine, free, and you can copy any of them straight off the page.

How to Use These Virtual Assistant Prompts

Anything in [square brackets] is yours to fill in: the client's name, their tone, the email you're working on. The more real detail you give, the better the answer.

You'll also see the same three habits in almost every prompt: ask me questions, flag what you're unsure about, and don't make things up. AI tools sometimes fill gaps with confident guesses. Those lines make it show you the gap instead, so you can check it before your client ever sees it.

One privacy rule before you paste anything. Leave out passwords, bank details and anything your client hasn't agreed to share with an AI tool. If you use Claude, its privacy settings have a toggle for whether your chats help train future models, and you can switch it off.

Inbox and Email

Email is where most of us start, so these come first. They sort, draft and nudge, and none of them send anything. You stay the one who hits send.

1. Sort this inbox

You're helping me manage [client name]'s inbox. Below are [number] emails. Sort them into: Reply today, Reply this week, FYI only, Can archive. Give one line on why for each. If you can't tell how urgent something is, put it under "Not sure" and tell me what you'd need to know. Don't guess at deadlines that aren't written in the email.
[paste emails]

2. Reply in my client's voice

Draft a reply to the email below for [client name], who is [role] at [company]. Their tone is [warm and brief / formal / casual]. The reply needs to [goal]. Keep it under [100] words. Don't promise dates, prices or anything that isn't in the email or my notes. If something is missing, write [CHECK: what's missing] in the draft instead of filling it in.
Email: [paste]
My notes: [paste]

3. Polite follow-up

Write a follow-up email to [recipient] about [topic]. We first wrote on [date] and haven't heard back. Give me two versions, one friendly and one firmer, both under 80 words. If you need the original email to get the details right, ask me for it first.

Calendar and Scheduling

Time zones are where small mistakes get expensive. These prompts make the AI show its working, so you can spot a wrong offset before a client misses a call.

4. Find a time across time zones

[Client name] is in [time zone] and works [hours]. The other person is in [time zone] and works [hours]. Suggest 3 meeting slots in the next [5 working days] that fit both working days. Show each slot in both time zones. If daylight saving time could change the offset on any of those dates, say so and tell me to double-check. Don't assume.

5. Review next week's calendar

Here is [client name]'s calendar for next week: [paste]. Point out double bookings, back-to-back meetings with no break, days with no time for focused work, and events missing a location or video link. Don't move anything. Just list what you'd flag and a suggested fix for each.

6. Offer meeting times by email

Write a short email to [person] offering these times for a [30-minute] call with [client name]: [times, with time zone]. Ask them to pick one or suggest another. Their time zone is [time zone]. If any slot falls on a weekend or very early or late for them, point it out to me before you write the email.

Meeting Notes

A transcript is only useful once someone pulls the decisions out of it. These three get you from messy notes to something your client will actually read.

7. Transcript to action items

Below is the transcript of [meeting name] on [date]. Pull out: decisions made, action items (with owner and due date) and open questions. Use only what's in the transcript. If an action item has no clear owner or date, write "owner unclear" or "no date given" instead of guessing.
[paste transcript]

8. Recap email

Turn these meeting notes into a recap email from [client name] to [attendees]. Start with the 3 most important decisions, then the action items with owners. Keep it under [200] words and easy to skim. Copy numbers and dates exactly as they appear, and mark anything that looks contradictory with [CHECK].
Notes: [paste]

9. Brief before a meeting

[Client name] is meeting [person or company] on [date] about [topic]. Using only what I paste below (past emails, their bio, old notes), write a one-page brief: who they are, what we've discussed before, open items, and 3 questions [client name] could ask. List anything important that's missing under "Gaps" at the end.
[paste]

Research

Research is where an AI is most tempted to sound sure when it isn't. Each of these asks it to separate what it knows from what you should check.

10. Compare options for a client

I'm researching [type of tool or service] for [client name], a [type of business] with a budget of [budget]. Compare [option A], [option B] and [option C] on price, main features and [what matters most to the client]. For every price or feature, tell me how sure you are. If you can't confirm current pricing, say so plainly so I can check the official site.

11. Quick research brief

Write a short research brief on [topic] for [client name], who needs it to [purpose]. Start with a 3-sentence summary, then the key points, then what's still uncertain or disputed. Keep facts you're confident about separate from things I should verify. Don't make up statistics or sources. If my request is unclear, ask me up to 3 questions before you start.

12. Find the claims I need to check

Here's a draft [post / email / report] for [client name]: [paste]. List every factual claim in it: numbers, dates, names and quotes. For each one, tell me whether it needs a source and what kind of source would confirm it. Don't mark anything as true unless it's common knowledge.

Client Communication

These are for the messages that need a bit of care: a tone fix, an awkward conversation, or the weekly update your client skims on their phone.

13. Fix the tone, keep the facts

Rewrite this message to [name] so it sounds [calmer / warmer / more professional]. Don't change any facts, dates or amounts. Under the rewrite, list what you changed and why in a few short lines.
[paste message]

14. A tricky message

Help me write a message to [client name] about [situation, e.g. a delay or a request outside our agreement]. What I want: [outcome]. What I can offer: [options]. Keep it honest and short, with no over-apologising. Ask me questions first if you need more context about our agreement.

15. Weekly update

Write a weekly update for [client name] from me, their VA. Done this week: [list]. In progress: [list]. What I need from them: [list]. Put the "need from you" part first and keep it under [150] words. Don't add tasks I didn't list.

Social Media

Good for first drafts of client posts. The rule in all three: no claims, prices or stats the client didn't give you.

16. Caption options

Write 3 caption options for [platform] for [client or brand]. Their audience is [audience] and their tone is [tone]. The post is about [topic or photo description]. End with this call to action: [CTA]. Keep each under [number] characters. Don't add claims, prices or stats I didn't give you.

17. Two-week content plan

Plan [2 weeks] of [platform] posts for [client name] using these themes: [themes] and these key dates: [launches, holidays]. Give me a table with date, post idea, format and an opening line. If a date might clash with something, like a public holiday in [country], flag it for me to check.

18. Repurpose one piece of content

Turn this [blog post / video transcript] from [client name] into [3] short [platform] posts. Use only points from the original and keep the client's own wording where you can. Flag any line you shortened in a way that might change the meaning.
[paste]

Documents and SOPs

An SOP is a standard operating procedure: written steps anyone could follow to do a task the same way. These turn your notes into documents without inventing missing steps.

19. Rough notes to SOP

Turn my rough notes below into a step-by-step SOP for [task] at [client's business]. Number the steps and add who does each one and which tool they use. Where my notes skip a step or aren't clear, add a [QUESTION: ...] line instead of filling the gap.
[paste notes]

20. Reusable template

Create a reusable template for [document type, e.g. onboarding checklist / meeting agenda / invoice reminder] for [client name]. Use [square brackets] for every detail that changes each time. Before you start, ask me which sections they usually include.

21. Proofread without rewriting

Proofread this [document] for spelling, grammar and consistency (names, dates, formatting). Don't change the style. Give me a list of each change with the original and the fix. If something looks factually wrong, flag it instead of changing it.
[paste]

Data Cleanup

Spreadsheet work is where a quiet AI guess can do the most damage. These keep blanks blank and leave the numbers alone.

22. Clean up a list

Below is a list of [contacts / products] from a spreadsheet. Fix capitalisation, split full names into first and last name, format phone numbers as [format] and remove exact duplicates. Don't invent missing data: leave blanks blank. At the end, list any rows you weren't sure about.
[paste]

23. Explain a formula

I'm working in [Google Sheets / Excel]. Column [A] has [what], column [B] has [what]. I want to [goal]. Give me the formula, explain in plain words what it does, and tell me what could break it, like empty cells or mixed date formats. Ask me for a sample row if you need one.

24. Spot problems, change nothing

Here is [client name]'s [expense list / invoice tracker]: [paste]. Point out possible problems: duplicates, missing dates, amounts that look unusual next to the rest, and totals that don't add up. Give the row for each one. Don't change any numbers.

Travel

Prices, visas and entry rules change, so these prompts make the AI organise and point you to official sources instead of quoting rules from memory.

25. Build the itinerary

[Client name] is travelling to [city] from [date] to [date] for [purpose]. Using the bookings I paste below, build a day-by-day itinerary with local times, confirmation numbers, addresses and travel time between stops. Flag any tight connection or anything missing, like a night with no hotel.
[paste bookings]

26. Shortlist options

Suggest [3] [hotels / areas to stay / flight routes] in [city] for [client name], who prefers [preferences] and has a budget of about [budget] per [night / trip]. Tell me what to search for and what to check. Don't state prices or availability as fact, because those change. I'll confirm on the booking site.

27. Pre-trip checklist

Make a pre-trip checklist for [client name]'s trip to [country] on [dates]: documents, apps, chargers, business etiquette and things to confirm 48 hours before. For anything about visas or entry rules, write "check the official government site" instead of giving rules from memory.

Managing Yourself

The last three are for you. Juggling several clients is a job in itself, and these help with the planning around the work.

28. Plan my day

Here is my task list for today across [number] clients: [paste]. I have [hours] hours and these fixed calls: [times]. Put the tasks in order with time blocks, deadlines first. If something won't fit, tell me what you'd move and ask me which client is safest to push.

29. End-of-day log

Turn these quick notes into a tidy end-of-day log for [client name]: what I finished, what's in progress, what's blocking me, and what's first tomorrow. Use only what I wrote.
[paste notes]

30. A personal assistant prompt for Claude

You're my assistant for [client name], a [role] at [company]. They prefer [tone] and [preferences, e.g. short emails, no meetings before 10 am, time zone]. When I give you a task: ask up to 3 questions if anything is unclear, never invent facts, dates, prices or names, mark anything you're unsure about with [CHECK], and never say something has been sent or booked. I do that part.

That last one works best as standing instructions. In Claude, you can save it as the instructions for a Project, which is a separate workspace with its own chats and files, so every chat inside it starts with your client's details already loaded. Free accounts can create up to five Projects.


What This Means for VAs

Prompts don't replace your judgment. They give it a head start. A good prompt gets you a draft in under a minute, and the [CHECK] marks show you exactly where your own knowledge of the client has to come in.

If you have a client who sends you a pile of meeting transcripts every week, start with prompt 7 and prompt 8 together. If inbox work eats your mornings, start with 1 and 2.

Then change the wording until it sounds like you and your client. The ones you end up using daily won't look exactly like mine, and that's how it should be.

Try one today, then tell me which prompt you started with.

A virtual assistant holding a blank recipe card next to a card box and a laptop How many times this week did you type "keep it short, ...