Skip to main content

Hi, I'm trying to build a task management system for children and parents using Manychat (WhatsApp), Google Sheets, and Make.com. I'd appreciate help in building this solution as I got stuck with this implementation.

Goal

Enable children to mark task completion, show them a relevant task list to choose from, get parent approval, and update token balance accordingly.

Existing Architecture

Google Sheets:

DB Structure
  • Contacts table: Parent and child information
  • DigitalWallet table: Token balance tracking
  • StatusTasks table: Task management

Manychat:

  • Users tagged as "parent" or "child"
  • Each contact (parent/child) has a user field named ChildID

Required Flow

  1. Child clicks "Completed Task" button
  2. System needs to:
    • Query Google Sheets for today's incomplete tasks
    • Dynamically generate Manychat menu/buttons
    • Maintain state during approval process
  4. Child selects task
  5. Parent notification and approval flow
  6. Token balance update upon approval

What I Need Help With

·  How to dynamically show only the relevant tasks for the specific child (ChildID) in ManyChat?

·  Best way to let the child select a single task from the list?

·  How to integrate Make.com (or just ManyChat) to send the approval request, wait for response, then update Google Sheets?

·  Any tips for handling delays (parent might approve hours/days later) or general best practices?

I'd particularly appreciate insights on the Make.com and Manychat module configuration.

 

Any help and guidance would be appreciated. Thanks!

Hey ​@Zoozing to achieve this I'd leverage Manychat's API and probably use Google Apps Script to code some custom-made functions to tailor to your needs and logic.

Then, either use Dynamic Content or set the information or map information to custom fields, and apply Manychat logic to correctly display the content.

I've built complex systems like this before, if you'd like I'd be happy to jump on a call to get to know each other and see if I can help you. Send me a DM if you're interested. ;)

Hey ​@Zoozing to achieve this I'd leverage Manychat's API and probably use Google Apps Script to code some custom-made functions to tailor to your needs and logic.

Then, either use Dynamic Content or set the information or map information to custom fields, and apply Manychat logic to correctly display the content.

I've built complex systems like this before, if you'd like I'd be happy to jump on a call to get to know each other and see if I can help you. Send me a DM if you're interested. ;)

Hi Gustavo, thanks for the suggestion, but I need to build it by myself without extra expenses..

Reply


Community Terms & ConditionsCookie settings