Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / KI-Agenten & Assistenten

KI-Agenten & Assistenten

Plant die Ansprache zur Umsatzrückgewinnung bei Solaranlagen mit Google Sheets, Gemini und WhatsApp

Jeden Morgen liest es Installations- und Zahlungsdaten aus Google Sheets, lässt Gemini einen geprüften Wiederherstellungsplan entwerfen, schreibt ihn zurück ins Sheet und versendet freigegebene WhatsApp-Nachfassnachrichten.

Was sie bewirkt

## Solar Installation Revenue Recovery Agent with automated Outbound ### How it works This workflow runs each morning to review solar installation operations and payment readiness data from Google Sheets. It builds a deterministic context, asks an AI agent to produce a revenue recovery action plan, validates the result, writes the plan back to Sheets, and sends approved WhatsApp outreach. Finally, it logs outbound messages so future runs can avoid duplicate or inappropriate follow-ups. ### Setup steps - Configure the Schedule Trigger for the desired daily run time and timezone. - Set the spreadsheet ID, company name, send mode, and WhatsApp phone number ID in the Config node. - Connect Google Sheets credentials with access to all required tabs, including sites, scheduled visits, utility approvals, technicians, payment milestones, parts, outbound history, and action plan/log tabs. - Configure the Google Gemini credential for the AI Agent chat model and ensure the structured output parser schema matches the expected action plan format. - Connect WhatsApp Business credentials and verify that message templates, phone number formatting, and dry-run/send-mode behavior are correct before enabling live outbound sends. ### Customization Adjust the readiness and validation logic in the Build Context, Validate Plan, Split Plan Rows, and Build Outbound Messages code nodes to match local business rules, sheet column names, WhatsApp templates, and escalation criteria. @youtube

Die Schritte

  1. Send WhatsApp Messages
  2. When Daily at 7AM
  3. Set Configuration Parameters
  4. Read Sites from Sheets
  5. Read Scheduled Visits from Sheets
  6. Read Utility Approvals from Sheets
  7. Read Technicians from Sheets
  8. Read Payment Milestones
  9. Read Parts from Sheets
  10. Read Outbound History
  11. Build Contextual Data
  12. Revenue Recovery AI Agent
  13. Google Gemini Chat Integration
  14. Parse Structured Outputs

Insgesamt 19 Schritte.

Ähnliche Automatisierungen