# How do we get CREDENTIALS\_CONFIG and DRIVE\_FOLDER\_ID for the google sheets MCP **URL:** \ **Category:** Actions\ **Tags:** actions\ **Created:** [July 11, 2025, 8:45pm UTC](https://community.pickaxe.co/t/how-do-we-get-credentials-config-and-drive-folder-id-for-the-google-sheets-mcp/6516 "2025-07-11T20:45:24Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![Ned.Malki](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.pickaxe.co/ned.malki/32/5918_2.png) [@Ned.Malki](https://community.pickaxe.co/u/Ned.Malki)\ **Post date:** [August 15, 2025, 12:49pm UTC](https://community.pickaxe.co/t/how-do-we-get-credentials-config-and-drive-folder-id-for-the-google-sheets-mcp/6516/4 "2025-08-15T12:49:03Z")
Hey @netmstr Great questions on this thread. Connecting to external services like Google Sheets using the custom MCP option can be an annoying task, especially when it comes to generating the right `credentials_config` JSON. There’s a much easier way to get this done that gives you more power and flexibility: **using [Make.com](http://Make.com) to create your tool (MCP Server).** Instead of wrestling with JSON credentials in Pickaxe, you can build a simple [Make.com](http://Make.com) scenario that connects to your Google Sheet. Make handles all the complicated authentication for you with a few clicks. Here’s a high-level overview of how you can set this up: ### **Step 1: Generate Your MCP Token in [Make.com](http://Make.com)** First, you need to get the security token that allows your Pickaxe tool to call your Make scenarios. 1. Log into your **[Make.com](http://Make.com)** account. 2. In the bottom-left corner, click your **user icon** and select **“Profile”** from the menu. 3. On the main dashboard, find and click on the **“API / MCP Tokens”** section. 4. Click **“Add token,”** give it a clear name (e.g., “Pickaxe Google Sheets Connection”), and click **“Save.”** 5. Make will generate a unique token. **Copy this token immediately** and store it somewhere safe. ![image](https://canada1.discourse-cdn.com/flex004/uploads/pickaxeproject/original/2X/8/815225e7e50ed69a8cce43909ff881912684c494.png) ![image](https://canada1.discourse-cdn.com/flex004/uploads/pickaxeproject/original/2X/b/ba72e71e8c3f13da2325fbcd5f1b81a0153d84e1.png) * * * ### **Step 2: Build Your Automation Scenario in [Make.com](http://Make.com)** Next, build the automation workflow in Make. This **scenario** will run whenever your Pickaxe tool calls it. 1. Create a **new scenario** in Make. 2. The trigger should be the default **“On demand”** setting. 3. Add your modules, such as the **“Google Sheets”** \> **“Add a Row”** module, and configure them. 4. Define the data your scenario will receive from Pickaxe. Go to **“Scenario settings”** (the gear icon) and click **“Scenario inputs.”** Add an input for each piece of data you need (e.g., an input named `new_row_data`). 5. Map the **Scenario input(s)** you just created to the fields in your Google Sheets module. * * * ### **Step 3: Connect Your Scenario to Your Pickaxe Tool** Finally, configure the **Action** in your Pickaxe tool to use this scenario. 1. In your Pickaxe tool’s **“Actions”** tab, add a new action. 2. In the URL field, construct a special URL using your Make server zone and the **MCP Token** you generated in Step 1. The format is: `https:///mcp/api/v1/u//sse` - Replace `` with your organization’s server (e.g., `eu2.make.com` or `us1.make.com`). - Replace `` with the token you copied from your profile. 1. Define the inputs in the Pickaxe UI to **exactly match the names** of the “Scenario inputs” you created in Make. ![image](https://canada1.discourse-cdn.com/flex004/uploads/pickaxeproject/original/2X/1/1b8c9d583be951d064f6e9782b9e467c84ab8447.png) And you’re done! Your Pickaxe agent can now send data directly to your Google Sheet through [Make.com](http://Make.com) without any complex configuration. This method is not only simpler but also more secure and easier to debug. Hope this helps clear things up! For getting the code right when connecting your MCP server, you can check out my post on this thread here: > [@How best for a Pickaxe to access data from a 3rd party data source's API](https://community.pickaxe.co/t/how-best-for-a-pickaxe-to-access-data-from-a-3rd-party-data-sources-api/6549/20): > > Here’s another MCP server code that works. Note: Sometimes the MCP connector in Pickaxe will give you the following error code: [image] Here is the code template to fix this: { "mcpServers": { "make-com-connector": { "command": "npx", "args": ["-y", "mcp-remote", "YOUR\_MAKE\_COM\_MCP\_ENDPOINT\_URL\_HERE"] } } } Note: The name “"make-com-connector"” is not required. You can name it whatever you want. ### If you prefer to go the Google Sheets MCP route, check out this post: > [@Checkout my bot connected to the Sequential Thinking MCP!](https://community.pickaxe.co/t/checkout-my-bot-connected-to-the-sequential-thinking-mcp/5975/6): > > This [https://github.com/xing5/mcp-google-sheets](https://github.com/xing5/mcp-google-sheets) Google Sheet MCP should work, If you follow [Method A](https://github.com/xing5/mcp-google-sheets?tab=readme-ov-file#method-a-service-account-recommended-for-serversautomation-) of setting up Auth but you have to convert the json file to base64 like one of their [uvx + CREDENTIALS\_CONFIG](https://github.com/xing5/mcp-google-sheets?tab=readme-ov-file#-usage-with-claude-desktop) example. { "mcpServers": { "google-sheets": { "command": "uvx", "args": ["mcp-google-sheets@latest"], "env": { // Paste the full Base64 string here "CREDENTIALS\_CONFIG": "ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCiAgInByb2plY3RfaWQiOiAi...", … > [@Checkout my bot connected to the Sequential Thinking MCP!](https://community.pickaxe.co/t/checkout-my-bot-connected-to-the-sequential-thinking-mcp/5975/10): > > Hi @ihmunro, Try encoding your json as base64 here: [https://www.base64encode.net/](https://www.base64encode.net/) --- _[View the full topic](https://community.pickaxe.co/t/how-do-we-get-credentials-config-and-drive-folder-id-for-the-google-sheets-mcp/6516)._