Формы и опросы
Копирование шаблонов Google Forms с Drive и отслеживание ответов через вебхуки
Запускается вручную, копирует шаблон Google Form, публикует копию, настраивает отслеживание ответов и передает каждую новую отправку на вебхуки для обработки.
Что делает
## Individual Google forms ### How it works 1. The workflow is manually triggered to start and copies a Google Form template. 2. The copied form is enhanced with additional details and published for circulation. 3. A watch is created to monitor responses to the published form. 4. Upon receiving a new form response, associated webhooks are called to process the data. 5. Responses are pulled, choices extracted, and a placeholder node handles the extracted information. 6. Error handling or optional user alerts can be integrated after response processing. ### Setup steps - [ ] Configure an OAuth 2 client (type "Web application" in the Google console - [ ] Then in n8n, we need a generic Oauth2 credential with this data: Grant Type Authorization Code Authorization URL https://accounts.google.com/o/oauth2/v2/auth Access Token URL https://oauth2.googleapis.com/token Client ID Client Secret Scope(s) - space sep https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/forms.body https://www.googleapis.com/auth/forms.responses.readonly - [ ] Create a template form (G-Form) - and remember the form ID (last part of the URL) - [ ] Put the form ID into "Set params" - [ ] Either edit "custname" (customer name) in "Set params" as well - or look it up from a G-Sheet et al - [ ] In "Modify form", adjust the form modification to your needs - [ ] Decide whether to use Google watches (then you need to create form-responses topic plus a subscription to the "Google watch" webhook in the Google console. Otherwise, remove the wait node and the "Google watch" flow, replace it with a periodic check on whether there's a response - [ ] Replace the "you could send a Mail here" with sending a mail or slack or whatsapp or ... (or leave it for testing) - [ ] Replace the "do sth with the choice" (or leave it for testing) - [ ] Create a n8n table with form_id and hook_url columns so we can remember which form belongs to which workflow execution. ### Customization Consider adding more detailed processing based on the form responses extracted.
Шаги
- When Workflow Executed
- Post Copy Form to Drive API
- Set Form Parameters
- Post Modify Form Fields
- Fetch Form Details
- Send Notification Email
- Post Create Form Watch
- Google Form Webhook
- Fetch Webhook Callback
- Wait for Watch Event
- Get Form Response Data
- Set Choice Data
- Process Choice Data
- Find Form Webhook Instance
Всего шагов: 16.
Похожие автоматизации
Файлы и облачное хранилищеBuild monthly mileage reimbursement reports from Google Calendar with OpenAI and DropboxШагов: 38Мониторинг, эксплуатация и инцидентыОтправка уведомлений о сбоях workflow n8n в Discord и запись в Data TableШагов: 7Синхронизация данных и ETLСоздание таблицы Snowflake, вставка и обновление данныхШагов: 6Автоматизация эл. почтыArchive IMAP email attachments to Folderit with verified data table receiptsШагов: 37