Polling Not Triggering
Problem
Your Google Sheets automation is set to auto-polling, but new or updated rows are not triggering document generation.Causes & Solutions
- Automation is inactive
- Polling interval
- Google account disconnected
- Row already processed
- Auto-creation was disabled
Verify your automation is active. Go to your automation settings and check the status toggle is turned on.
Manual Trigger Queue Issues
Problem
When using manual trigger mode with Google Sheets, documents are queued but not completing, or the queue appears stuck.Solution
Check queue status
Open your automation and check the queue panel. Each workspace is limited to 50 queued jobs and 5 active jobs at a time.
Verify Google connection
Go to Settings > Integrations and confirm your Google account is connected. An expired token will cause all queued jobs to fail.
If many jobs fail at once, it’s usually a connection issue. Fix the root cause, then re-trigger the failed rows.
Row Number Problems
Problem
Documents are generated with data from the wrong row, or the row number reference doesn’t match what you expect.Causes
- Header row: DocsAutomator treats the first row as headers. Row 2 in your sheet is row number 1 in the data.
- Empty rows: Blank rows in the middle of your sheet can cause row numbering to shift unexpectedly.
- Filtered views: If your sheet has active filters, the visible row numbers differ from the actual row positions.
Solution
- Ensure your sheet has no empty rows between data rows
- Remove any active filters before triggering document generation
- Remember that row numbering starts at 2 (row 1 is the header row)
Formula Fields Not Resolving
Problem
Placeholder values show formula expressions instead of the computed results, or appear blank.Causes & Solutions
- Volatile formulas: Some formulas (like
NOW(),RAND()) may not resolve in time. Add a small delay or use static values where possible. - Cross-sheet references: Formulas referencing other sheets may take longer to calculate. Ensure all referenced sheets are accessible.
- Error values: If a formula returns
#ERROR!,#REF!, or#N/A, DocsAutomator will pass the error string as the value. Fix the formula in your sheet first.
Webhook Formula Showing #ERROR
Problem
The webhook formula you pasted into Google Sheets shows a#ERROR! result.
Solution
This typically happens when your Google Sheets language is not set to English. The formula syntax uses English function names and comma separators.- Go to File > Settings in your Google Sheet
- Change the Locale to an English-speaking region (e.g., United States)
- Re-paste the webhook formula from DocsAutomator
Alternatively, you can manually translate the function names and replace commas with semicolons for your locale.
Related
Google Sheets Integration
Complete Google Sheets setup guide
Run History
Monitor document generation history