Bibliothek / Formulare & Umfragen
Formulare & Umfragen
Google-Formular-Vorlagen mit Drive kopieren und Antworten über Webhooks überwachen
Manuell gestartet: kopiert eine Google-Formular-Vorlage, veröffentlicht die Kopie, richtet eine Antwortüberwachung ein und leitet jede neue Einsendung zur Verarbeitung an Webhooks weiter.
Was sie bewirkt
## 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.
Die Schritte
- 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
Insgesamt 16 Schritte.
Ähnliche Automatisierungen
Web Scraping & RechercheUber-Eats-Pizzaangebote mit Bright Data finden4 SchritteMonitoring, Betrieb & StörungenSend grouped failed execution digests via Data Tables, email, and webhooks18 SchritteFinanzen, Rechnungen & BuchhaltungQersh-Wallet-Überweisungen aus Webhooks protokollieren und verifizieren in Google Sheets16 SchritteCode, Git & Entwicklertoolsn8n-Webhooks testen, ohne die Webhook-URL zu ändern92 Schritte