Ask about expenses in your messenger — an instant answer from your sheet

Ask about spending in plain words in your messenger — the scenario understands it with AI, computes from your expense sheet, and sends the answer.

  • Ask in plain words, no formulas
  • AI understands category, period and who spent
  • The answer is computed from your expense sheet
  • An unclear category is clarified with buttons
Google SheetsTelegram
Set it up for yourselfScriptera

How it works

To move data from WhatsApp Business Cloud to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: MSG | Telegram Inbound
  2. Check: IF | Message or Callback?
  3. If yes: IF | User Authorized?
  4. If yes: LLM | Parse Intent
  5. Then: JS | Extract Intent JSON
  6. Check: IF | Category Present?
  7. If yes: MERGE | Combine Category + Person
  8. Then: JS | Merge Intent Fields
  9. Then: SET | Assemble Resolved Intent
  10. Then: GS | Load Expenses
  11. Check: MERGE | Combine Expenses + Categories
  12. Then: JS | Filter & Aggregate
  13. Then: JS | Format Response Message
  14. Then: TG | Send Reply
  15. Then: GS | Load Categories
  16. If no: SPLIT | Split Categories
  17. Check: MERGE | Join Categories with Mapping
  18. Then: SET | Normalize Category
  19. Check: MERGE | Check Category against Allowed
  20. Check: IF | Category Known?
  21. If yes: MERGE | Combine Categories with List
  22. Check: LOOP | Iterate Categories
  23. Check: MERGE | Loop Entry (Category)
  24. Then: SET | Set Resolved Category
  25. Then: AGG | Aggregate Resolved Categories
  26. Then: LLM | Classify Category
  27. Then: SET | Extract LLM Category
  28. Then: TG | Confirm Category Suggestion
  29. Check: IF | Category Suggestion Accepted?
  30. If yes: SET | Set New+Old Category (LLM)
  31. Check: MERGE | Combine Category Mapping Entries
  32. Then: GS | Save Category Mapping
  33. If no: JS | Build Category Inline Buttons
  34. Then: HTTP | Send Category Selection Message
  35. Then: WAIT | Wait for Category Selection
  36. Then: SET | Read Callback Body (Cat.)
  37. Then: SET | Set New+Old Category (Selection)
  38. If no: GS | Read Category Mapping
  39. If no: GS | Read Allowed Categories
  40. Then: AGG | Aggregate Category List
  41. Check: IF | Person Present?
  42. If yes: MERGE | Combine Person Mapping
  43. If no: SPLIT | Split Persons
  44. Check: MERGE | Join Persons with Mapping
  45. Then: SET | Normalize Person
  46. Check: MERGE | Check Person against Allowed
  47. Check: IF | Person Known?
  48. If yes: MERGE | Combine Persons with List
  49. Check: LOOP | Iterate Persons
  50. Check: MERGE | Loop Entry (Person)
  51. Then: SET | Set Resolved Person
  52. Then: LLM | Classify Person
  53. Then: SET | Extract LLM Person
  54. Then: TG | Confirm Person Suggestion
  55. Check: IF | Person Suggestion Accepted?
  56. If yes: SET | Set New+Old Person (LLM)
  57. Check: MERGE | Combine Person Mapping Entries
  58. Then: GS | Save Person Mapping
  59. If no: JS | Build Person Inline Buttons
  60. Then: HTTP | Send Person Selection Message
  61. Then: WAIT | Wait for Person Selection
  62. Then: SET | Read Callback Body (Person)
  63. Then: SET | Set New+Old Person (Selection)
  64. If no: GS | Read Person Mapping
  65. If no: GS | Read Allowed Persons
  66. Then: AGG | Aggregate Person List
  67. If no: IF | Category or Person Callback?
  68. If yes: JS | Read Category Callback
  69. Then: HTTP | Forward Category Selection
  70. Then: TG | Confirm Category Selection
  71. If no: JS | Read Person Callback
  72. Then: HTTP | Forward Person Selection
  73. Then: TG | Confirm Person Selection

You can launch this WhatsApp Business Cloud + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios