Google Sheets Import & Export: Read Public Sheets, No OAuth
Pricing
from $0.15 / 1,000 results
Pulls Google Sheets Import & Export down to one paste: drop a public sheet link and get every tab as clean JSON or CSV rows with tab name and row number. No OAuth, no Google account, no API key - just google sheets to json.
You can access the Google Sheets Import & Export: Read Public Sheets, No OAuth programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.
{ "mcpServers": { "apify": { "type": "http", "url": "https://mcp.apify.com/?tools=fetch-actor-details,h1018y/anvil-google-sheets-all" } }}The configuration above connects to the hosted Apify MCP server with the Google Sheets Import & Export: Read Public Sheets, No OAuth Actor already loaded. It uses OAuth, so your client opens a browser window to sign you in to Apify on first use. No API token is needed. Clients without OAuth support can authenticate with an Authorization: Bearer header carrying an API token from API & Integrations in Apify Console.
Get a ready-to-use configuration for your MCP client with the Google Sheets Import & Export: Read Public Sheets, No OAuth Actor preconfigured at https://mcp.apify.com/?tools=fetch-actor-details,h1018y/anvil-google-sheets-all.
You can connect to the Apify MCP Server using clients like Tester MCP Client, or any other MCP client of your choice.
If you want to learn more about our Apify MCP implementation, check out our MCP documentation. To learn more about the Model Context Protocol in general, refer to the official MCP documentation or read our blog post.