Below I have my workflow. I need help with the telegram bot to do these functions with make.com. Let me know who can help for me to pay.
Complete Workflow for AI to Build in Make.com (Including Approval & Rejection Messages)
This workflow automates the entire Google Review signup, tracking, and verification process using Google Forms, Google Sheets (Excel), and Make.com.
Trigger: Watch New Google Form Submissions
• Trigger Type: Google Forms submission
• Data Captured:
• Telegram Username
• Google Email
• Business Name
• Wave # (Pre-set in the form title)
•
Automatically triggers as soon as a reviewer submits the form
Check for Duplicate Business Reviews in Google Sheets
• Search Google Sheets (Master Review Tracking Sheet) for:
• Telegram Username
• Business Name
• Condition:
•
If user has NOT reviewed this business before → Proceed to approval
•
If user has ALREADY reviewed this business in a past wave → Reject signup
Send a Telegram Message Based on Qualification
Qualified Reviewer Message
• Trigger: Reviewer passes duplicate check
• Action: Send this Telegram message to the user:
Congratulations {{Telegram Username}}!
You have been approved to leave a review for {{Business Name}}.
We will notify you on your assigned day to leave the review.
After posting, send your screenshot via DM to this bot.
Make sure to follow the guidelines!
•
Reviewer gets instant confirmation that they were accepted
Non-Qualified Reviewer Message (Already Reviewed This Business)
• Trigger: Reviewer fails duplicate check
• Action: Send this Telegram message to the user:
Sorry {{Telegram Username}}, you have already reviewed {{Business Name}} in a previous wave.
You can still apply to review other businesses in the future!
•
Prevents duplicate reviews for the same business
Add Approved Reviewer to Google Sheets
• Sheet: Master Review Tracking Sheet
• Data Stored:
• Telegram Username
• Google Email
• Business Name
• Wave #
• Review Date (Auto-assigned by Make.com)
• Screenshot Submitted? (No)
•
Now, only new & approved reviewers are stored
Track Approved Review Count & Stop Signups at 15
• Count total approved reviewers for this business & wave in Google Sheets
• Condition:
•
If count is less than 15, allow signups
•
If count reaches 15, stop accepting new signups
• Action:
• If count = 15, Make.com sends a message to the admin to disable the Google Form manually.
Assign Review Days & Schedule Telegram Message
• Automatically assign review days (3-5 reviews per day)
• Store assignment in Google Sheets
• Schedule Telegram messages for assigned reviewers on the correct day
•
Ensures that reviews happen in controlled waves without flooding Google at once
Send Review Instructions & Google Review Link via Telegram Bot
• Trigger: Assigned review day arrives
• Message Sent:
It’s time to leave your review for {{Business Name}}!
Here is the review link: {{Review URL}}
After leaving your review, send a screenshot to the bot.
Guidelines:
- Make it natural, no copy-pasting
- Use 4-5 sentences
- Post within 12 hours
•
Prevents reviewers from reviewing too early
Watch for Screenshot Submissions via Telegram DM
• Trigger: User sends an image to the Telegram bot
• Filter: Accept only images (ignore text messages)
• Log submission in Google Sheets:
• Screenshot Submitted? (Yes)
Verify Review & Process Payments
• Admin verifies the review manually in Google Sheets
• Trigger: When admin marks “Verified? = Yes”
• Action:
•
Send payment confirmation message to reviewer
•
Add user to weekly payout list
Final Workflow Summary (Automated by Make.com)
Reviewers sign up via Google Forms
Make.com checks Google Sheets to prevent duplicate business reviews
Qualified reviewers receive an approval message
Disqualified reviewers receive a rejection message
Only 15 reviewers per wave are approved
Make.com schedules review link messages on the correct day
Telegram bot receives & logs screenshots in Google Sheets
Admins verify reviews & Make.com tracks payments