How to set up, deploy, and connect Google Scripts to Make.com for task automation.

Published: October 24, 2024

Trigger automated report, slide and email

By leveraging platforms like Flowise AI and Make.com, you can interact with and execute tasks in voice and natural language text with:

• your business data warehouses,
• thousands of platforms (Zoho, Quick Books, Salesforce, AWS, Google, Microsoft, Azure, Slack HubSpot, Stripe, Woo Commerce, Shopify....)
• and most importantly your own existing API's

The implementations are relatively rapid, with part of it being no-code, and any coding being done by AI-assisted coding tools.

In Part 3 of my series on Building AI / LLM Voice Action Agents, I show how to set up, deploy, and connect Google Scripts to Make.com for task automation.

App

• Custom Frontend : React.js
• Rapid Deploy Frontend : Flowise
• Automation Scripts: Google Script
• AWS MySQL DB Connection: Flowise ReAct Agent & Custom built FastAPI Server

Detailed hands-on implementation guide, available on my YouTube playlist:

How to Build Voice-Based LLM Action Agents

Automate tasks, processes, and query databases

• Part 1: Demo, Architecture, and Tracing Agent Process Flow Step-by-Step
• Part 2: Update Excel, Google Sheets, and Databases with LLM Voice Agents
• Part 3: Automate tasks with LLM Voice Agents and Google Script.

Source code, JSON schema, Blueprints, Google Scripts at my GitHub repo:

This code, deployed as-is, gives a fully functional voice bot (with limited app features).

Demo App (with restricted features) available at vtexer-shared.tigzig.com

Use the demo OpenAI API key shared at:

What's next:

• Part 4: Build Custom Frontend with Natural Language Instructions
• Part 5: More ReAct Agents in Flowise & Deploy to Vercel