AI chatbot for social media + lead collection in Google Sheets
1. Project Goal
Set up a unified system for automated communication with clients on social media and messengers using ChatGPT, with automatic collection and transfer of leads to Google Sheets.
The system must:
automatically respond to clients;
qualify requests;
collect contact information;
transfer leads to Google Sheets.
2. Channels to Connect
It is necessary to set up work through the SendPulse platform for the following channels:
Instagram (business account)
Facebook Page
TikTok Business
Telegram (bot)
WhatsApp Business API
❗ Personal accounts are not used.
3. Main Logic of Operation
The client sends a message in any of the channels
The message goes to SendPulse
ChatGPT (via AI Agent) automatically:
responds to the client;
asks clarifying questions;
collects lead data
After receiving the contacts:
a final message is sent to the client;
the data is automatically recorded in Google Sheets
4. Requirements for GPT (AI Agent)
GPT must work as a sales manager.
Responsibilities of GPT:
conduct a dialogue in a business, polite style;
clarify the client's needs;
request contact (phone or email);
specify the city and deadlines;
not invent information;
not write long responses;
upon receiving the contact, inform that the manager will get in touch.
The performer must:
correctly integrate GPT into SendPulse;
set up data transfer from the dialogue to variables.
5. Variables to Collect
Mandatory:
Name
Phone OR Email
Client Request
Additional:
City
Deadlines
Channel (Instagram / Facebook / TikTok / Telegram / WhatsApp)
6. Google Sheets
It is necessary to:
connect SendPulse → Google Sheets integration;
create or connect a table;
set up automatic row addition for new leads.
Table Structure:
Date
Channel
Name
Phone
Email
City
Request
Status (New)
7. Chatbot Scenario (minimum)
Incoming message → AI Agent
Check: is there a contact
If there is no contact — GPT requests again
After receiving the contact:
message to the client
sending data to Google Sheets
8. What the Performer Must Do
✔ Connect all channels to SendPulse
✔ Set up AI Agent (ChatGPT)
✔ Create chatbot scenario
✔ Set up Google Sheets
✔ Test the entire process
✔ Provide access and a brief instruction
9. Work Result
The client receives:
a fully operational system;
automated communication with clients;
leads in Google Sheets;
scalability options.
10. Requirements for the Performer
experience with SendPulse is mandatory;
understanding of chatbots and automations;
experience with ChatGPT integrations;
ability to work with Google Sheets API or integrations.
11. Submission Format
demonstration of work (screencast or live show);
access to SendPulse;
access to Google Sheets;
brief instruction (text)
-
15 days1265 USD15 days1265 USD
Hello, Alexander!
I am in 2nd place on the platform and specialize in developing chatbots and automating business processes. I work with services such as n8n/Make.com.
I have repeatedly implemented AI agents/consultants for integration into social networks, so we can easily do it for you as well. I am attaching a case.
https://freelancehunt.com/showcase/work/ai-agent-dlya-internet-magazina-zdorovogo-pitaniya/1950472.html
You can check out similar works in my portfolio:Freelancehunt
Feel free to reach out, I would be happy to discuss your project in more detail.
-
10 days121 USD10 days121 USD
Hello, Oleksandr! Thank you for the detailed brief. The task is clear. The project is interesting. I have experience with bots on the SendPulse platform. I also work with Make.com automations. I would be happy to collaborate. I invite you to private messages to discuss the details. Have a good evening!
-
10 days619 USD
1315 7 0 10 days619 USDGood day.
I am ready to take your project into work.
I can set up a chat-bot for you based on SendPulse and n8n (optionally).
Write to me privately, we will discuss all the details and can start the implementation.
-
5 days108 USD
824 4 0 5 days108 USDHello, Alexander!
SendPulse has ready-made integrations for all channels + ChatGPT AI Agent, so the logic is simple: message → GPT (collects name, contact, request, city, deadlines, channel) → entry in Google Sheets.
Potential problems and solutions:
- WhatsApp: Meta verification may take 3-7 days. Solution: I will verify the number immediately, prepare templates in advance.
- Instagram/FB: Permission conflicts with other bots. Solution: I will set up the SendPulse "handover protocol" as the primary one.
- TikTok: Limit of 10 messages/48 hours after the first contact. Solution: GPT will be brief, focusing on quick information gathering.
My plan: I will connect the channels, set up the AI Agent with your instructions (business style, variable collection), the bot script with contact verification, integration with Google Sheets, end-to-end testing.
Please let me know: Is WhatsApp verified? Have there been any bots on Instagram/FB before?
Let's discuss in detail!
-
10 days404 USD
537 2 0 10 days404 USDGood day! Oleksandr, I have reviewed your technical specifications.
I create AI assistants for businesses based on the Planfix platform — a system that combines CRM, process automation, and artificial intelligence capabilities.
Most companies today build their solutions from a "zoo" of separate tools — bots, spreadsheets, APIs, forms, CRMs, and chats that exist independently of each other. Each service solves a specific task, but together they create chaos: data is duplicated, processes are interrupted, and businesses lose the big picture.
We solve this problem differently.
Planfix is not just a CRM, but a full-fledged operating system for business that unites communication, customer base, tasks, documents, finances, process automation, and analytics in one environment.
Any tool — from the AI assistant to accounting or customer chat — operates within a single data context. This eliminates the chaos of the "zoo" and creates an interconnected system where each process logically follows another.
… The AI assistant is just one part of this ecosystem.
It functions within your Planfix working environment, has access to all necessary information, and can not only answer questions but also:
— create tasks,
— update statuses,
— generate reports,
— analyze correspondence,
— or initiate actions in the CRM — in the context of your business, not outside of it.
Advantages of the solution:
— direct connection Planfix ↔ OpenAI, without intermediaries — budget savings and minimal technical difficulties;
— convenient interface for control: you can monitor the assistant's work, enable moderation or delegation;
— intelligent triggers: Planfix can independently reach out to the AI assistant when a client does not respond, a date or event occurs — the assistant acts proactively;
— a single platform for development: easily add new scenarios, channels (Instagram, Telegram, email, Google Forms, WhatsApp, etc.) without losing the business context.
The result is not just a bot or integration, but a smart assistant that lives in your system, understands its context, and becomes part of your business processes.
I am ready to adapt the solution to your case and show how the AI assistant can truly relieve your team.
-
1 day108 USD
172 1 1 1 day108 USDHello! I am ready to complete this project and have extensive experience in developing various applications.
-
1 day108 USD
215 1 day108 USDHello,
I can create a fully functioning automated communication system with clients on social media and messaging apps, based on ChatGPT, with automatic collection and transfer of leads to Google Sheets.
The scope of my work includes:
• Connecting all specified channels (Instagram, Facebook Page, TikTok Business, Telegram, WhatsApp Business) to SendPulse.
• Configuring the AI Agent (ChatGPT) for automated customer service, qualification of inquiries, and collection of contact data.
• Saving all leads to Google Sheets in the specified structure (Date, Channel, Name, Phone, Email, City, Inquiry, Status).
• Preparing the chatbot script and testing the entire process.
… • Providing access and a brief user manual.
Price for the entire project: 400 PLN.
I will deliver a functioning system ready for use, with the possibility of further scalable automation.
Best regards.
-
10 days135 USD
589 2 0 10 days135 USDHello! I am an n8n specialist with experience in developing bots for business process automation. I will implement your project through n8n or in Python, ensuring stable integration of ChatGPT with all channels and automatic lead transfer to Google Sheets. I am ready to discuss technical details and quickly set up a turnkey system.
-
2 days108 USD
7134 13 0 2 days108 USDHello, I have done a similar task, example https://217-154-170-186.nip.io/ I would be happy to implement this task and do everything in the best way.
-
4 days108 USD
3160 23 1 3 4 days108 USDYour task of integrating ChatGPT for automatic communication with clients and lead collection in Google Sheets is exactly the complex system that I can confidently implement. My experience with SendPulse allows me to offer a reliable solution that supports all specified channels and ensures smooth data transfer. In addition to clear AI setup, I will also create scenarios and integrations that track every step. I have previously successfully implemented similar projects using the Google Sheets API, so I am confident in the accuracy of execution. Let's discuss your project in more detail!
-
10 days135 USD
631 3 0 10 days135 USDGood day, the project is interesting, I would like to participate)
I will be concise, I can do this, the stack is familiar to me, the technical specifications are absolutely clear.
I have experience working with AI integrations both with code and without it using AI agents (sendPulse, n8n).
Write to me, I am sure we will work well together)
-
5 days188 USD
586 1 0 5 days188 USDHello! The task of automating lead generation through SendPulse is completely clear to me. I specialize in implementing AI agents that work not in "autoresponder" mode, but in the mode of an active sales manager. I will implement your project using no-code tools, which will provide you with flexibility: you will be able to adjust the script or add channels without contacting developers.
I will pay special attention to data quality: I will set up a system prompt for ChatGPT so that it gently but persistently qualifies the lead, collecting the city and deadlines before transferring to Google Sheets. I will also implement a check for "empty" dialogues to ensure your table is not cluttered with random messages. I am ready to set up integration with all channels (including WhatsApp and TikTok) and test the funnel for "AI hallucinations" to ensure responses are concise and strictly within your business context. Please let me know if you already have a verified WhatsApp Business API or if you need help connecting it.
-
30 days108 USD
2259 5 1 30 days108 USDHello! I have reviewed your assignment and believe that I can successfully complete it. I would be happy to collaborate, please write to me personally for further details.
-
7 days108 USD
296 7 days108 USDHello! I have carefully reviewed your assignment and I am confident that I can complete it efficiently and on time. I would be happy to have the opportunity to collaborate. Please contact me personally to discuss further details.
-
5 days215 USD
19003 461 0 7 5 days215 USDGood evening Alexander, I am interested in your project and would be happy to collaborate. I have experience working with SendPulse, and I also work with n8n, so there will be no issues with execution. I would be glad to discuss the details. Have a good evening!