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
The MCPs are really amazing, will they be available on all plans?
3 Likes
Hi, it will be treated as regular actions.
1 Like
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.
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
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
}
}
}
}
2 Likes
@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.
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
- Go to Google Cloud Console
- Select your project (same one from before)
- Go to âIAM & Adminâ â âService Accountsâ
Step 2: Create Service Account
- Click â+ CREATE SERVICE ACCOUNTâ
- Name: âMCP Google Sheetsâ
- Description: âFor PickAxe MCP integrationâ
- Click CREATE AND CONTINUE
Step 3: Add Permissions
- Role: Select âEditorâ (or âGoogle Drive API Service Agentâ)
- Click CONTINUE â DONE
Step 4: Generate Key
- Click on your new service account
- Go to âKeysâ tab
- Click âADD KEYâ â âCreate new keyâ
- Choose âJSONâ format
- Download the JSON file
Step 5: Convert to Base64
- Open the downloaded JSON file
- Copy the entire contents
- 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
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
Hi @ihmunro,
Try encoding your json as base64 here: https://www.base64encode.net/
1 Like
Hi @stephenasuncion
I now have it working. Appreciate it.
2 Likes