@actionsflow/trigger-google_form

@actionsflow/trigger-google_form

This is a google_form trigger of Actionsflow. Any new response in Google Form will trigger the trigger.

This is an official trigger, you don't need to install it manually.

View trigger on Github

Prerequisites

You should Create a custom script at google form More->Script Editor

1. paste the following script to the editor, change the WEBHOOK_URL to yours.

   var WEBHOOK_URL =
     "https://webhook.actionsflow.workers.dev/<owner>/<repo>/<workflow-file-name>/google_form?__token=<your-github-personal-token>";
   
   function onFormSubmit(e) {
     var response = e.response;
     var source = e.source;
     var itemResponses = response.getItemResponses();
     var definition = {
       title: source.getTitle(),
       fields: [],
     };
     const formItems = source.getItems();
     for (var i = 0; i < formItems.length; i++) {
       const formItem = formItems[i];
       definition.fields.push({
         id: formItem.getId(),
         title: formItem.getTitle(),
         type: formItem.getType(),
         index: formItem.getIndex(),
       });
     }
   
     var answers = [];
     for (var j = 0; j < itemResponses.length; j++) {
       var itemResponse = itemResponses[j];
       const formItem = itemResponse.getItem();
       answers.push({
         response: itemResponse.getResponse(),
         field: {
           id: formItem.getId(),
           title: formItem.getTitle(),
           type: formItem.getType(),
           index: formItem.getIndex(),
         },
       });
     }
     var webhookPayload = {
       event_id: response.getId(),
       event_type: "form_response",
       form_response: {
         form_id: source.getId(),
         email: response.getRespondentEmail(),
         submitted_at: response.getTimestamp().toISOString(),
         definition: definition,
         answers: answers,
       },
     };
     var options = {
       method: "post",
       contentType: "application/json",
       payload: JSON.stringify(webhookPayload),
     };
     UrlFetchApp.fetch(WEBHOOK_URL, options);
   }
   

2. Add a trigger by selecting Current project's triggers in the Edit menu, and creating a new trigger using the settings given below. Save it.

Usage

on:
  google_form:

Options

There is nothing can be specified. You can use General Config for Actionsflow Trigger for more customization.

Outputs

This trigger's outputs will be the body of the aws sns message body, you can see it here

An outputs example:

{
  "event_id": "2_ABaOnud0S_zjpIn9oGqBpmY65p_NsuiBSqvdwPlapEig0GM4EPdeStVqalzlAb3AEovoWgA",
  "event_type": "form_response",
  "form_response": {
    "form_id": "118EoaS7eK2qvWv8tQy3xLKa-MGgRAizQvO5PKVArWG4",
    "email": "",
    "submitted_at": "2020-09-27T07:54:30.661Z",
    "definition": {
      "title": "test formt",
      "fields": [
        {
          "id": 440714388,
          "title": "question 1",
          "type": "MULTIPLE_CHOICE",
          "index": 0
        },
        {
          "id": 886865551,
          "title": "name",
          "type": "TEXT",
          "index": 1
        }
      ]
    },
    "answers": [
      {
        "response": "Option 2",
        "field": {
          "id": 440714388,
          "title": "question 1",
          "type": "MULTIPLE_CHOICE",
          "index": 0
        }
      },
      {
        "response": "test",
        "field": {
          "id": 886865551,
          "title": "name",
          "type": "TEXT",
          "index": 1
        }
      }
    ]
  },
  "answers_map": {
    "question 1": "Option 2",
    "name": "test"
  }
}

You can use the outputs like this:

on:
  google_form:
jobs:
  print:
    name: Print
    runs-on: ubuntu-latest
    steps:
      - name: Print Outputs
        env:
          answer: ${{ toJSON(on.google_form.outputs.answers_map) }}
        run: |
          echo answer: $answer