Connect Google Sheets to AI Agent using Zapier MCP Server

Data Entry Agent Instructions

Configuring the Zapier MCP Server

1. Navigate to mcp.zapier.com in a new browser tab.
2. Log in to your Zapier account.
3. Click the 'New MCP Server' button at the top of the dashboard.
4. Select 'OpenAI Agent Builder' from the 'Select client' dropdown menu.
5. Enter a name for the server (e.g., 'Lead Gen Agent') in the 'Name your server' field.
6. Click 'Create server'.
7. Click 'Google Sheets' from the list of available tools.
8. Select the action 'Create Spreadsheet Row'.
9. Click the dropdown for 'Connection' and select your connected Google Drive account.
10. Under the 'Spreadsheet' field configuration, select 'Set a specific value'.
11. Choose the specific pre-created Google Sheet file from the dropdown list.
12. Under the 'Worksheet' field configuration, select 'Set a specific value' and choose 'Sheet1' (or the relevant tab name).
13. Leave the data fields (Columns) as default/blank to allow the AI to populate them dynamically.
14. Click 'Save' to finalize the server configuration.
15. Locate the 'Connect to OpenAI' section at the top of the page.
16. Click 'Copy' next to the generated API Key.

Integrating Zapier MCP into the AI Agent

1. Return to the Agent Builder interface.
2. Drag a new 'Agent' node onto the canvas.
3. Click and drag from the handle of the previous node to connect it to this new Agent node.
4. Click the new Agent node to open its settings.
5. Click 'Tools' in the settings panel.
6. Click the '+' (plus) sign to add a tool.
7. Select 'MCP Server' from the options list.
8. Paste the API Key copied from Zapier into the API Key field.
9. Uncheck the box that says 'Allow agent to add and edit other tools' (to strictly limit the agent's scope).
10. Click 'Add' to connect the server.
11. Click the newly added 'Google Sheets' tool in the list to open its specific settings.
12. Locate the 'Approval' setting.
13. Change the setting from 'Always require approval' to 'Never require approval' (to automate the process fully).
14. Click 'Update' to save the permission changes.