Google Sheets

1. On your integromat site, you can click on the + icon (Add another module) button

2. Next, you can type/search the tool that you want to use. In this tutorial we will be using Google Sheets to add new row at our existing Sheets . Click on it to mark it.

3. After that, you can choose the actions that you want to use. We will be using Add a row for this tutorial.

4. Next, you can just ignore the empty field and click on the Add button

5. You will need to insert your Google sheets connection name for your reference at the field given. Then click on the Continue button

6. Once you click on the Continue button, a new tab will be automatically open from your browser and you will be needed to Sign in to the Google Account that have the Google sheets you want to integrate with.

7. After you already Sign in and allow all the required settings for integromat integrations. You need to choose the Google Sheets file that have the sheets that you want to be add with new row from the Spreadsheet field.

8. Next, you need to choose which Sheet you want the row to be add at. If your Sheet table have header, you can choose Yes for the Table contains header field

9. Once the settings already done, you can click on the OK button

10. You will need to run your webhook once, to make sure that you are able to insert the parameter value at your Google Sheets module settings. You can just click on the Run once button and trigger the webhook by submitting your form details at your Pages site.

11. Once your webhook already been triggered and the value already received, you can go back to Integromat and click on the Google Sheets module

12. After that, you can go to the Values section and add the parameter value to your sheets row.

13. This is an example on how your setting will looks like once you already include all the value to their respected rows.

All of the data that is being captured or sent to your integromat is based on the field that is in your form at your Pages site.

14. Once all the settings had been made, you can click on the OK button

15. Once you have done all this step, do not forget to save your work by click on the Save button

16. Next, you need to make sure this scenario is active by clicking on the Scheduling toggle.

17. On the pop up, you can choose when you want to run the scenario. After that, you can click on the Activate button to turn on this scenario

Here is how your scenario will looks like when it is active.

Last updated