# Radius filter from a Google Drive file to Google Sheets with AI | InstaMaps > Radius filter from a Google Drive file to Google Sheets, in Claude, ChatGPT, Copilot or Gemini. Source: https://get-instamaps.com/workflows/google-drive-file-radius-filter-to-google-sheets [InstaMaps](/) [Features](#features)[How It Works](#how-it-works)[Tools](/tools)[Store Locator](/store-locator)[Blog](/blog)[Support](/support) [ Get Started ](https://workspace.google.com/marketplace/app/instamaps/103204565785?utm%5Fsource=get-instamaps&utm%5Fmedium=site&utm%5Fcampaign=header) [Workflows](/workflows) / Radius filter # Radius filter from a Google Drive file to Google Sheets Which rows are within a distance of your sites, and the nearest site to each. Ask your AI in plain English: it reads a Google Drive file, InstaMaps does the location work, and the results land in Google Sheets. ![](/logos/google-drive.svg)Google Drive file → ![InstaMaps](/main_logo.png)InstaMaps Radius filter → ![](/logos/google-sheets.svg)Google Sheets Works in![](/logos/claude.svg)Claude![](/logos/chatgpt.svg)ChatGPT![](/logos/copilot.svg)Copilot![](/logos/gemini.svg)Gemini [Add InstaMaps to your AI →](#setup) Free connector · sign in with Google · about a minute ## The prompt Using the rows in this CSV or Excel file in my Google Drive: , keep the rows within 25 miles of any of our sites () and say which site is nearest to each, and put the results in a new tab of this Google Sheet: . Replace the parts in . ## What comes back * The nearest site and its distance in miles * Within the radius: yes or no * Anything that can't be placed or answered comes back with the reason. Nothing is dropped. ## Set it up ### ![](/logos/claude.svg)Radius filter 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. Paste the prompt above. [Claude's own guide ↗](https://support.claude.com/en/articles/11175166-get-started-with-custom-connectors-using-remote-mcp) ### ![](/logos/chatgpt.svg)Radius filter in ChatGPT Business, Enterprise and Edu workspaces (in beta). An admin turns on developer mode first: Workspace Settings, then Permissions & Roles, then Connected Data. 1. Go to chatgpt.com/plugins, click +, then "Add custom MCP server". 2. Name it InstaMaps. Under Connection, enter https://get-instamaps.com/mcp as the server URL and choose OAuth. 3. Click "I understand and want to continue", then "Create as a plugin", and install it. Sign in with Google when asked. 4. Paste the prompt above. [ChatGPT's own guide ↗](https://developers.openai.com/api/docs/guides/custom-mcp-server) ### ![](/logos/copilot.svg)Radius filter in Microsoft Copilot and Teams Through Copilot Studio, with a Copilot Studio licence. Your Microsoft 365 admin approves the agent before the rest of the organisation can use it. 1. In Copilot Studio, open your agent, then Tools, "Add a tool", "New tool", and choose Model Context Protocol. 2. Name it InstaMaps, enter https://get-instamaps.com/mcp as the server URL, choose OAuth 2.0 with dynamic discovery, then Create and "Add to agent". 3. Publish the agent, then under Channels choose "Teams and Microsoft Copilot" and "Add channel". Share it from Availability options. 4. Paste the prompt above. [Microsoft Copilot and Teams's own guide ↗](https://learn.microsoft.com/en-us/microsoft-copilot-studio/mcp-add-existing-server-to-agent) ### ![](/logos/gemini.svg)Radius filter in Gemini The Gemini app with a personal Google account (US, 18 and over, English). Work accounts use Gemini Enterprise, where an admin adds InstaMaps: write to hello@get-instamaps.com for the sign-in details it needs. 1. On gemini.google.com, open Settings, then Connected Apps. 2. Under Custom apps, click "Add a custom app" and enter https://get-instamaps.com/mcp. Click Next and sign in with Google. 3. In a chat, type @ and pick InstaMaps to use it. 4. Paste the prompt above. [Gemini's own guide ↗](https://support.google.com/gemini/answer/17209137) ## Before you start ![](/logos/google-drive.svg)Reading a Google Drive file Share the file with InstaMaps, or set it to "anyone with the link can view". InstaMaps reads it straight from Drive. ![](/logos/google-sheets.svg)Writing to Google Sheets InstaMaps writes to the sheet itself: share it with the address the answer gives you, as Editor. It adds new dated columns or a new tab, and never overwrites a cell. ## Run it on a schedule Every Monday at 8am: using the rows in this CSV or Excel file in my Google Drive: , keep the rows within 25 miles of any of our sites () and say which site is nearest to each, and put the results in a new tab of this Google Sheet: . * ![](/logos/claude.svg)**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. * ![](/logos/chatgpt.svg)**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. * ![](/logos/copilot.svg)**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. * ![](/logos/gemini.svg)**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 * Distances are straight-line, which is fast and works on any size of list. For miles by road, use the road mileage workflow. * 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](/tools/radius-map). ## Related workflows [![](/logos/google-sheets.svg)→![](/logos/google-sheets.svg)Radius filter in Google Sheets](/workflows/google-sheets-radius-filter-to-google-sheets)[![](/logos/google-sheets.svg)→![](/logos/gmail.svg)Radius filter from Google Sheets to Gmail](/workflows/google-sheets-radius-filter-to-gmail)[![](/logos/google-drive.svg)→![](/logos/gmail.svg)Radius filter from a Google Drive file to Gmail](/workflows/google-drive-file-radius-filter-to-gmail)[![](/logos/gmail.svg)→![](/logos/google-sheets.svg)Radius filter from Gmail to Google Sheets](/workflows/gmail-radius-filter-to-google-sheets)[![](/logos/gmail.svg)→![](/logos/gmail.svg)Radius filter in Gmail](/workflows/gmail-radius-filter-to-gmail)[![](/logos/google-drive.svg)→![](/logos/google-sheets.svg)Geocoded address list from a Google Drive file to Google Sheets](/workflows/google-drive-file-geocode-to-google-sheets) InstaMaps Territory mapping and routing for Google Sheets™. ### Product * [Features](#features) * [How It Works](#how-it-works) * [Sheets Formulas](/formulas) * [100-Stop Route Planner](/tools/multi-stop-route-planner) * [Dispatch Software](/blog/dispatch-software) * [Route Optimization](/blog/route-optimization-software) ### Company * [About](#) * [Blog](/blog) * [Free Tools](/tools) * [Store Locator](/store-locator) * [Careers](#) * [Contact](#) ### Resources * [Setup Guide](/docs/setup) * [Help Center](/docs/help) * [Documentation](/docs) * [Press Map: Closed UK Pubs](/press/closed-pubs) * [Free Batch Geocoder](/tools/geocoder) * [HUBZone Checker](/tools/hubzone-checker) * [Census Tract Lookup](/tools/census-tract-lookup) * [Opportunity Zone Checker](/tools/opportunity-zone-checker) * [USDA Eligibility Checker](/tools/usda-eligibility-checker) * [Flood Zone Checker](/tools/flood-zone-checker) * [Flood Zones Explained](/flood-zones) * [Population Within a Radius](/tools/population-within-radius) * [Conservation Area Checker](/tools/conservation-area-checker) * [Flood Zone Checker (England)](/tools/uk-flood-zone-checker) * [UPRN Lookup](/tools/uprn-lookup) * [Service Area Map](/tools/service-area-map) * [Multi-Driver Route Planner](/tools/multi-driver-route-planner) * [Postcode Distance (UK)](/tools/postcode-distance-calculator) * [ZIP Codes in a Radius](/tools/zip-codes-in-radius) * [Sales Route Planner](/blog/sales-route-planner-free) * [Territory Mapping](/blog/free-territory-mapping-software) * [Report Issue](mailto:hello@get-instamaps.com?subject=Something%20isn%27t%20working) ### Legal & Support * [Privacy Policy](/privacy) * [Terms of Service](/terms) * [Support](/support) * [Admin Config](/dashboard/settings/admin) ### [InstaMaps by use case](/for) [Lead distance](/for/lead-distance)[Circle prospecting](/for/circle-prospecting)[Door knocking](/for/door-knocking)[Cleaning schedules](/for/cleaning-business-scheduling)[Field service routes](/for/field-service-routes)[Sales territories](/for/sales-territory-mapping)[Driving for dollars](/for/driving-for-dollars)[Site verification](/for/site-verification)[Store locators](/for/store-locator)[Property listings](/for/real-estate-listings)[Address cleanup](/for/property-data-cleanup)[Delivery routes](/for/delivery-routes)[Field service](/for/field-service-jobs)[Trip planning](/for/travel-itinerary)[School mapping](/for/school-mapping)[field service](/for/home-care) © 2026 InstaMaps. All rights reserved.