Build an AI Business Analyst, for $0.01/month!
automate your sales funnel, using Google's App Script!
Hey everyone!
Back with another automation project! This time, we’re ditching Python and embedding OpenAI directly into the Google Ecosystem using App Script (sorry Gemini, we will try you next time!)
For this project, we will be focusing on lead scoring.
If you’re in an established service business, you probably have a lead scoring system going already. If you don’t, a lead scoring system is set up due to a pretty simple reason: it’s pretty ineffective for you to take calls with every single inbound prospect, so you need a way to score them quickly and accurately.
Having a form for prospects to fill out is great, but manually reviewing them can be painful, and creating a fixed-reponse selection form doesn’t really provide enough insight on what the potential client actually wants.
So, let’s build an AI business analyst to score them autonomously.
Remember: You can get a step-by-step tutorial on this project using our AI tutor, PrompterGPT. Simply choose which project you’d like to work on, follow the instructions, and tell it what you want changed!
Application Steps:
Link a Google Form to your website, a prospect will fill out, answering some basic questions.
In the code (will be shared shortly) define your ideal customer - along with timelines, product type, marketing goals, etc. This is what the prospect’s form responses will be scored against.
When responses are submitted, in an new column, a score with reasoning will be populated.
App Demo:
Tech Stack:
Google Sheets
Google Forms
OpenAI’s GPT-4o mini
Google App Script
Technical Workflow:
Sounds good? Let’s get to work. Click the button below to start building. PrompterGPT will walk you through the project step-by-step and help you troubleshoot, customize, or edit its scope. Just ask away!
Happy building, and see you next time.
— Nishad from Prompter
P.S. This project doesn’t interest you? Check out last week’s project on how to build your own Competitor Website Monitor!
P.P.S for more daily thoughts on AI, and sneak peak of projects before they’re sent, make sure to follow us on X!