Creating an Integration Trigger for 'Google Sheets'

The 'Google Sheets' integration trigger is required for automatic execution of actions or launching scenarios when data is updated in Google Sheets.

1. To create a trigger, go to the 'Integration triggers' section and click on the 'Google Sheets' block. 

2. Click the 'Create trigger' button and select the event you're interested in. In this example, it's 'VPBX: End of an incoming call' when the number is linked to Virtual PBX. Then click 'Next'. 

3. A settings window will open. Fill in the fields:

   • Trigger name;

   • Selected integration — choose the integration. For more details, see 'Integration with Google Sheets service'.

   • Google Spreadsheet ID — you can get it from the address bar of your opened Google spreadsheet.

   • Name of the sheet — the name of the sheet from your Google spreadsheet.

   • Fill in the remaining fields with the data you need. Fields can be filled with both text values and variables listed in the available parameters.

     To add the desired variable to a field, simply click on the available parameter with your mouse. 

4. Fill in the fields and click 'Save'. This completes the integration setup. 

5. You can proceed to testing the functionality. Now, every time a call ends, your Google Sheets table will be populated with the necessary data, as shown in the screenshot below.

See also:

'Integration with Google Sheets service'

'Integration with Altegio'