Quick overview
Quick overview This workflow runs on demand to match security questionnaire questions against an approved-answer library in Notion, then creates a Google Docs draft and notifies reviewers in Slack, optionally updating a Notion tracker page. How it works Starts manually to run a test questionnaire and load configuration values like the Notion database ID, Google Drive folder ID, and confidence threshold. Loads a list of questionnaire questions and queries the Notion database for answers whose Status equals the configured approved value. Compares each questionnaire question to the approved Notion questions, selects the closest match, and marks low-confidence matches as “Needs review” instead of auto-answering. Branches based on whether any answers need review and posts a corresponding Slack notification to the configured review channel. Builds a formatted draft body containing each question, match confidence, owner, and either the approved answer or a “Needs review” placeholder. Creates a new Google Docs document for the draft and optionally updates a Notion questionnaire tracker page with “Draft ready for review” and the needs-review count. Setup Add Notion credentials and set the approved-answers database ID, ensuring it has a Select property named “Status” with an “Approved” option. Add Google Docs OAuth credentials (and optionally provide a Google Docs template ID if you plan to extend the workflow to populate content via batchUpdate). Add Slack OAuth credentials and set the review Slack channel ID used for notifications. Update the variables for minimum match confidence, customer name, and (optionally) a Notion tracker page ID if you want the workflow to write back status updates. Requirements Notion database with approved security answers. Google Docs OAuth credentials. Slack OAuth credentials with permission to post messages. Optional Notion tracker page for questionnaire status updates. Customization Replace the sample question loader with Google Drive, Gmail, Typeform, or another intake source. Adapt the matching logic to your Notion database properties and confidence rules. Customize the Google Docs draft body with your company’s required review sections. Adjust Slack notifications for different reviewers or channels. An n8n automation workflow template by Dyogo Henrique de Oliveira Ortega.
Dyogo Henrique de Oliveira Ortega
web
free
Others in the same category, ranked by how often they are opened.
