Checkout my bot connected to the Sequential Thinking MCP!

Actions
1

1. Sequential Thinking bot Click here to try

2. Song Insight Click here to try

  • Chatbot connected to the Sequential Thinking & fetch MCP server working alongside Google search & Eleven labs action.
6 Likes
2

The MCPs are really amazing, will they be available on all plans?

3 Likes
3

Hi, it will be treated as regular actions.

1 Like
4

MCP is exciting!

How do we trigger the MCPs?

I’ve added the json for Google sheets oath but not sure how to setup the action trigger and info collector.

Also I checked out your song insights and I’m getting an error.

IMG_4551
IMG_45511125×2436 225 KB

5

Hey @spaceduck2001,

To trigger MCPs, you can either explicitly mention the tools or use the prompt frame to do it automatically.

We haven’t tested for Google MCPs yet, I’ll let you know once we do. I think we need to do something in our part for credentials to work.

As for my Song Insight Pickaxe, I ran out of ElevenLabs credits, haha.

1 Like
6

This https://github.com/xing5/mcp-google-sheets Google Sheet MCP should work, If you follow Method A of setting up Auth but you have to convert the json file to base64 like one of their uvx + CREDENTIALS_CONFIG example.

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        // Paste the full Base64 string here
        "CREDENTIALS_CONFIG": "ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCiAgInByb2plY3RfaWQiOiAi...",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here" // Still needed for Service Account folder context
      }
    }
  }
}

image
image905×265 16.4 KB

2 Likes
7

@stephenasuncion

I am not having much luck with getting this connected.

The generation of the CREDENTIALS_CONFIG is no easy feat and not a lot of help out there to be able to generate it.

8

Hey @ihmunro,

I haven’t got it to read my files yet so take this with a grain of salt but I was able to generate credentials_config following the directions below (provided to me by a combo of Claude and Perplexity). Good luck!

How to Get Service Account Credentials

Step 1: Google Cloud Console

  1. Go to Google Cloud Console
  2. Select your project (same one from before)
  3. Go to “IAM & Admin” → “Service Accounts”

Step 2: Create Service Account

  1. Click “+ CREATE SERVICE ACCOUNT”
  2. Name: “MCP Google Sheets”
  3. Description: “For PickAxe MCP integration”
  4. Click CREATE AND CONTINUE

Step 3: Add Permissions

  1. Role: Select “Editor” (or “Google Drive API Service Agent”)
  2. Click CONTINUE → DONE

Step 4: Generate Key

  1. Click on your new service account
  2. Go to “Keys” tab
  3. Click “ADD KEY” → “Create new key”
  4. Choose “JSON” format
  5. Download the JSON file

Step 5: Convert to Base64

  1. Open the downloaded JSON file
  2. Copy the entire contents
  3. Convert to Base64:

A. Open your browser’s developer console (F12 or right-click → Inspect → Console).
Type: const myJson = {paste your copied JSON here};
press enter
Returns: undefined (normal)

B. Convert the JSON object to a string:
Type: const jsonString = JSON.stringify(myJson);
press enter
Returns: undefined (normal)

C. Encode the string to Base64:
Type: const base64String = btoa(encodeURIComponent(jsonString).replace(/%([0-9A-F]{2})/g, function(match, p1) { return String.fromCharCode(‘0x’ + p1); }));
press enter
Returns: undefined (normal)

D. View Base64
Type: base64String
press enter
returns credentials: “eyJ0eXBlIjoic2VydmljZV9hY2NvdW50In0=”
(or similar, depending on your input)

Also, don’t forget to give your “client_email” edit access to your google drive folder.

1 Like
9

When I add this in, I get the following error

Uncaught SyntaxError: Invalid or unexpected token\

I modified to

const base64String = btoa(
encodeURIComponent(jsonString).replace(/%([0-9A-F]{2})/g, function(match, p1) {
return String.fromCharCode(parseInt(p1, 16));
})
);

So I got a huge number starting with ey ending in 0=

I added both this plus drive ID.

Still not working.

I get the error

Checking for the Contacts Google Sheet.

I encountered an error while trying to list the spreadsheets, so I cannot confirm if the “Contacts” Google Sheet is available. If you have a specific folder or location where the spreadsheets are stored, please let me know, or provide more details about the spreadsheets you’d like to work with.

1 Like
10

Hi @ihmunro,

Try encoding your json as base64 here: https://www.base64encode.net/

1 Like
11

Hi @stephenasuncion

I now have it working. Appreciate it.

2 Likes