Перейти к содержанию
НОВОЕМаркетплейс и trig8n Agent: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Формы и опросы

Формы и опросы

Create invoice drafts from chat or forms with Claude and Google Workspace

When a form is submitted, it processes form answers with Claude using Gmail, Google Drive.

Что делает

## Create invoice drafts from a sentence, without letting AI do the math Ask in Google Chat or on a form: "Aoba, September" or "Blue Harbor の先月分". Claude only reads who and which month. Code checks that reading against your words and computes every amount and date from your Google Sheet. Then a copy of your Google Docs template is filled in, saved as PDF and attached to a Gmail draft. Nothing is sent: a person opens the draft and sends it. ### It stops instead of guessing - a customer not in the Customers tab, or words that do not match its name - no month, or a month Claude read differently from the words - no lines, too many lines, or a quantity or price that is not a number - an invoice number that was already created (set its status to void to redo it) ### Setup 1. Credentials: Google Sheets, Google Drive, Google Docs, Gmail (OAuth2) and Anthropic. 2. Make a spreadsheet with tabs Customers, Items, Invoices and a Google Docs template (columns and placeholders in the description). 3. In Config, paste the spreadsheet ID and template doc ID and write your company details. 4. Try the form first. For Google Chat, see section 1.

Шаги

  1. Request form
  2. Google Chat event
  3. Chat settings
  4. Read the chat event
  5. Is it a request?
  6. Reply in Chat
  7. Config
  8. Read the spreadsheet
  9. Parse the sheets
  10. Claude Haiku 4.5
  11. Read the request
  12. Check the reading
  13. Reading OK?
  14. Build the invoice

Всего шагов: 25.

Похожие автоматизации