İçeriğe geç
YENİPazar yeri ve ekibin: geliştirdiğini sat; planlar ve değişiklikler sen görmeden önce test edilsin. Yeniliklere bak

Kütüphane / Formlar ve Anketler

Formlar ve Anketler

Drive ile Google Form şablonlarını kopyala ve yanıtları webhook'lar üzerinden izle

Manuel olarak tetiklenir, bir Google Form şablonunu kopyalar, kopyayı yayınlar, yanıt izleyicisi kurar ve her yeni gönderimi işlenmek üzere webhook'lara iletir.

Ne yapar

## 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.

Adımlar

  1. When Workflow Executed
  2. Post Copy Form to Drive API
  3. Set Form Parameters
  4. Post Modify Form Fields
  5. Fetch Form Details
  6. Send Notification Email
  7. Post Create Form Watch
  8. Google Form Webhook
  9. Fetch Webhook Callback
  10. Wait for Watch Event
  11. Get Form Response Data
  12. Set Choice Data
  13. Process Choice Data
  14. Find Form Webhook Instance

Toplam 16 adım.

Benzer otomasyonlar