InstaMaps
Workflows / Driver routes

Driver routes from Google Sheets to a Google Drive file

Stops split across drivers, in the best order, with a Google Maps link for each driver. Ask your AI in plain English: it reads Google Sheets, InstaMaps does the location work, and the results land in a Google Drive file.

Google Sheets
InstaMapsInstaMaps
Driver routes
Google Drive file
Works inClaudeChatGPTCopilotGemini
Add InstaMaps to your AI →
Free connector · sign in with Google · about a minute

The prompt

Using the rows in this Google Sheet: <link to your sheet>, plan routes for 2 drivers starting from <your depot address>, with an 8-hour shift and 15 minutes at each stop, and save the results to my Google Drive as a CSV file called "Driver routes".

Replace the parts in <angle brackets>.

What comes back

  • Each driver's stops in order, with arrival times
  • A Google Maps link per driver to drive from
  • Any stops that don't fit the shift, with the reason
  • Anything that can't be placed or answered comes back with the reason. Nothing is dropped.

Set it up

Driver routes in Claude

Every plan, including Free. On Free, InstaMaps uses your one custom connector; Google Drive, Gmail and Google Calendar are directory connectors and don't count against it.

  1. In Claude, open Settings, then Connectors, and choose "Add custom connector".
  2. Name it InstaMaps and paste https://get-instamaps.com/mcp. Click Add.
  3. Click Connect and continue with Google. You land back in Claude, ready to ask.
  4. Add the Google Drive, Gmail or Google Calendar connector from the same Connectors page when the chain uses them.
  5. Paste the prompt above.
Claude's own guide ↗

Before you start

Reading Google Sheets

Share the sheet with InstaMaps, or set it to "anyone with the link can view". InstaMaps reads it straight from Google, so a sheet of thousands of rows is one call, and nothing passes through the chat.

Writing to a Google Drive file

Your AI tool's Google Drive connector saves the file.

Run it on a schedule

Every weekday at 7am, for that day's stops: using the rows in this Google Sheet: <link to your sheet>, plan routes for 2 drivers starting from <your depot address>, with an 8-hour shift and 15 minutes at each stop, and save the results to my Google Drive as a CSV file called "Driver routes".

  • Claude. Scheduled tasks run a prompt hourly, daily, on weekdays or weekly, with the connectors you've added. They need a paid plan (Pro, Max, Team or Enterprise), and on Pro and Max they run in the cloud, so your computer can be off.
  • ChatGPT. ChatGPT has scheduled tasks, but OpenAI doesn't yet say whether they can use a custom connector. Run the prompt by hand until it does.
  • Microsoft Copilot and Teams. Copilot Studio agents can run on a schedule with a Recurrence trigger. The run uses the agent author's sign-ins.
  • Gemini. Google doesn't yet say whether scheduled actions can use a custom app. Run the prompt by hand until it does.

Good to know

  • Up to 100 stops and 10 drivers per plan, on roads in Great Britain and the US. Google Maps picks the roads when the driver opens the link.
  • The connector is free: 5,000 tool calls a day per person, and a whole sheet read by link counts as one call.
  • Rather do it without an AI? Use the free tool on our site.

Related workflows

Driver routes in Google SheetsDriver routes from Google Sheets to GmailDriver routes from Google Sheets to Google CalendarDriver routes from a Google Drive file to Google SheetsDriver routes in Google Drive fileDriver routes from a Google Drive file to Gmail