Google Sheets Import & Export (Ctrio Lab)

com.ctriolabPublished by ctriolab.comv0.1.0Updated Oct 24, 2026

Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.

VerifiedStreamable HTTPWeb executableData & Analytics

Overview

AI-generated overview

Lets an assistant write Apify datasets or JSON rows into a Google Sheet, or read a sheet back as JSON, through Apify.

What you can do
Write Apify dataset contents or JSON rows into a Google Sheet, creating or filling the target sheet and range. Read an existing Google Sheet and return its contents as JSON rows for further use.
When to use it
Useful when you already collect data in Apify datasets and want it placed into a spreadsheet, or when you need sheet contents turned into JSON for downstream processing without manual copy-paste. It is not a general spreadsheet editing or formula tool. It is not a general spreadsheet editing or formula tool. It is not a general spreadsheet editing or formula tool. It is not a general spreadsheet editing or formula tool. It is not a general spreadsheet editing or formula tool. It is not a general
Requirements
A remote MCP endpoint at mcp.apify.com with OAuth sign-in or an Apify API token passed in the Authorization header. An Apify account with billing enabled and access to the target Google Sheet.
Before you install
Requires an Apify API token sent as an Authorization bearer header, and runs are billed to your Apify account on a pay-per-result basis. Writing to a sheet changes data in that spreadsheet, so check the target sheet and range before letting an assistant run an import.

Installation

In SourceWeft

  1. Open Google Sheets Import & Export (Ctrio Lab) in the dashboard and add it to a workspace.
  2. Connect the required credentials. They are stored privately and never shown on public pages.
  3. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/com.ctriolab%2Fgoogle-sheets/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config. The client completes OAuth sign-in on first connect.

{
  "mcpServers": {
    "google-sheets-import-export-ctrio-lab": {
      "type": "http",
      "url": "https://mcp.apify.com/?tools=ctriolab/google-sheets-import-export"
    }
  }
}

Tools

0
This server asks you to sign in, so SourceWeft could not read its tools without an account and has not indexed them. What a connected account sees can depend on that account and its permissions.

Version history

1
  1. v0.1.0LatestOct 24, 2026

Score

67% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts

    Declare a GitHub repository with a README, or serve resource_documentation in the OAuth protected-resource metadata.

  • LicenseNot applicable

    A hosted service is used under its provider's terms, so no license is expected here. This check is left out of the percentage.