Workflow
The system:
- Receives a processing request through a webhook
- Retrieves pending agreement records from Google Sheets
- Generates agreements automatically from document templates
- Retrieves pending invoice records from Google Sheets
- Generates invoices automatically from predefined templates
- Creates a standardized customer name for file management
- Searches Google Drive for the customer folder
- Creates a new customer folder when required
- Generates the customer sales pitch from a template
- Updates SmartSuite with success or failure status
- Marks processed records in Google Sheets
- Handles existing folders and Google Drive processing errors



