Apps
Google Calendar
39 min
learn how to connect engini to google calendar using engini’s google calendar activities, you can create events, update details, check availability, and manage your calendar effortlessly to get started with the google calendar app, create a free account at google com or use your organizational google workspace account getting started with google sheets prerequisites a google calendar account add a connection to google sheets in engini enter your engini account at https //app engini io/ navigate to connections page by clicking on the connections on the left sidebar or by clicking https //app engini io/connections click on the new integration option located at the topbar choose google calendar option from the available applications enter the details in the “add connection” form note there are two different authentication methods available, and the required fields differ depending on the option you choose please follow the relevant instructions based on your selected method oauth2 this method uses a predefined authentication flow you don’t need to provide a client id or client secret, you simply sign in using your account connection name enter unique identifier for the connection within engini authentication method select oauth2 click on the “sign in with google” button sign into your google account fields automatically populated post connecting to a google account include access token a token for authorization to access google services refresh token a token used to obtain a new access token when the current one expires click on the save settings button to save the connection custom oauth2 this method requires you to configure your own oauth2 credentials you must provide both a valid client id and client secret obtained from your google cloud console project connection name choose a unique identifier for the connection within engini authentication method select custom oauth2 when connecting to google services using a custom oauth client to learn more about this authentication, enter https //app archbee com/public/preview ixqqblwfxopjg0nave78y/preview pge7hsn11qgbublnn0zz#yhkxl client id enter the client id from the oauth 2 0 credentials in the google cloud project c lient secret enter the client secret from the same set of oauth 2 0 credentials in the google cloud project access token & refresh token automatically populated post connecting to a your google account sign in with google click sign in with google and log in with the google account used to create the project in google cloud this ensures access to the correct oauth credentials and permissions click on the save settings button to save the connection triggers check for events the trigger monitors google calendar, listening for new or updated events in the connected calendar at scheduled intervals as defined calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account starting (utc) – select the start date and time for the scheduled trigger recur every – choose the time interval for triggering and checking emails the minimum time interval is 15 minutes add time frame – you can specify a time frame during which the trigger will operate click on “add time frame” button select a specific time frame to activate the trigger for example, every 15 minutes from 8 am to 5 pm top n specifies the maximum number of entries to retrieve, with a default setting of all entries if left blank add sorting choose to sort if necessary click in “add sorting” button to select an item from the list, click the small arrow choose the field on which you want to apply the sorting from the drop down select the order of the sorting add conditions choose to add conditions if necessary click in “add condition” button to select an item from the list, click the small arrow choose the field on which you want to apply the condition from the drop down select the desired operator from the drop down list enter the value that the item should match actions create calendar this action creates a new calendar in the connected google calendar account, allowing you to organize events under a dedicated calendar summary the name of the calendar to be created this title will appear in your google calendar and help identify the calendar among others get calendar this action retrieves details of a specific calendar from the connected google calendar account, allowing you to access its configuration and metadata calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account get calendar list this action retrieves a list of all calendars available in the connected google calendar account, allowing you to view and work with multiple calendars within your workflows add filter you can specify which records will be returned from the search results by utilizing the “add filter” button choose from the drop down the field you want to filter by select the condition you want the record to meet for the selected field click on the field to show the tooltip with all the options you can choose you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 4 for all the fields you want to populate update calendar this action updates an existing calendar in the connected google calendar account, allowing you to modify its details and settings as needed calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate delete calendar this action deletes an existing calendar from the connected google calendar account, removing it and all its associated events permanently calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account clear calendar this action removes all events from a specific calendar in the connected google calendar account, while keeping the calendar itself intact calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account create event (full create) this action allows you to create a detailed event in the selected google calendar, providing full control over scheduling and event configuration calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account type of creation defines the method used to create the event in this case, full create is selected, which allows you to provide full event details such as start and end time, along with additional fields for a more detailed and customized event setup start date time the start date and time of the event in iso format (yyyy mm ddthh\ mm\ ssz) end date time the end date and time of the event in iso format (yyyy mm ddthh\ mm\ ssz) add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate create event (quick create) this action creates a new event in the selected google calendar, allowing you to schedule meetings or activities calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account type of creation defines the method used to create the event in this case, quick create is selected, which allows you to create an event using a simple text input text a natural language input used to quickly create an event (for example “meeting tomorrow at 10am”) the system will automatically parse the details and create the event accordingly add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate get event this action retrieves the details of a specific event from the selected google calendar calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account event id the unique identifier of the event you want to retrieve add filter you can specify which records will be returned from the search results by utilizing the “add filter” button choose from the drop down the field you want to filter by select the condition you want the record to meet for the selected field click on the field to show the tooltip with all the options you can choose you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 4 for all the fields you want to populate get events this action retrieves a list of events from the selected google calendar, allowing you to work with multiple events within your workflows calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account top n specifies the maximum number of entries to retrieve, with a default setting of all entries if left blank add filter you can specify which records will be returned from the search results by utilizing the “add filter” button choose from the drop down the field you want to filter by select the condition you want the record to meet for the selected field click on the field to show the tooltip with all the options you can choose you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 4 for all the fields you want to populate add sorting choose to sort if necessary click in “add sorting” button to select an item from the list, click the small arrow choose the field on which you want to apply the sorting from the drop down select the order of the sorting update event this action updates an existing event in the selected google calendar, allowing you to modify its details and schedule calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account event id the unique identifier of the event you want to retrieve start date time the start date and time of the event in iso format (yyyy mm ddthh\ mm\ ssz) end date time the end date and time of the event in iso format (yyyy mm ddthh\ mm\ ssz) add filters you can specify which records will be returned from the search results by utilizing the “add filter” button choose from the drop down the field you want to filter by select the condition you want the record to meet for the selected field click on the field to show the tooltip with all the options you can choose you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 4 for all the fields you want to populate add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate delete event this action deletes a specific event from the selected google calendar, removing it permanently calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account event id the unique identifier of the event you want to retrieve add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate create access control rule this action creates a new access control rule for a specific calendar, allowing you to define permissions and sharing settings for other users calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account role defines the level of access granted (for example reader, writer, owner) scope type defines the type of entity the rule applies to (such as user, group, or domain) get access control rule this action retrieves the details of a specific access control rule from the selected calendar, allowing you to view its permissions and sharing configuration calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account rule id the unique identifier of the access control rule you want to get (after selecting a calendar) get access control rules this action retrieves a list of access control rules from the selected calendar, allowing you to view all sharing and permission settings calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account add filter you can specify which records will be returned from the search results by utilizing the “add filter” button choose from the drop down the field you want to filter by select the condition you want the record to meet for the selected field click on the field to show the tooltip with all the options you can choose you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 4 for all the fields you want to populate update access control rule this action updates an existing access control rule for a specific calendar, allowing you to modify permissions and sharing settings calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account rule id the unique identifier of the access control rule you want to update (after selecting a calendar) scope type defines the type of entity the rule applies to (such as user, group, or domain) add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate delete access control rule this action deletes an existing access control rule from the selected calendar, removing the defined permission or sharing configuration calendar id the unique identifier of the calendar you want to retrieve this value is used to specify which calendar to fetch from your account rule id the unique identifier of the access control rule you want to delete (after selecting a calendar) get availability information this action retrieves availability (free/busy) information for one or more calendars within a specified time range, helping you determine scheduling conflicts or open time slots start time the beginning of the time range for which availability is checked, in iso format end time the end of the time range for which availability is checked, in iso format items \[] a list of calendars or resources for which availability information is requested add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate initialize objects array this activity initializes a new variable designed to hold an array of objects of a specific google calendar type variable name – enter a name for the variable that will store the array of objects object element type – select the type of object that this variable will contain this determines the structure and available fields for each item in the list add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate append object to array this action adds a new object to an existing object array variable that was initialized earlier in the workflow variable – select the object that each item in the list represents this defines the structure and available fields for each item during the mapping process add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate map array this activity transforms a list of data into an array of google calendar compatible objects data list – select the list of items you want to transform this can be a variable or output from a previous step object name – select the type of object that each item in the list represents this defines the structure and available fields for each item during the mapping process add field allows you to dynamically add and update additional calendar properties as needed choose from the drop down the field you want to fill click on the empty field to the right of the drop down to be shown the tooltip with all the options you can use to fill the field you can populate the field in one of the following options static value number / string when using strings, you need to surround them with single quotes (') property value from a previous activity (using the tooltip that opens when clicking on the field) expression using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate send api request this activity allows you to send a custom api request directly to the google calendar base url – this is the root url of the api you’re sending the request to relative url – you can specify additional path segments or parameters that need to be added to the end of the automatically generated url this allows you to customize the specific request you want to perform method – select the http method (e g , get, post, put, delete, patch) body type – defines the format of the data in the body of your request commonly used values include application/json (as shown), which means the body will contain a json formatted payload body – contains any data that is being sent to the server add headers – additional metadata about the request, such as the type of data the engini can accept, the length of the request body, and authentication information add queries – the query refers to the parameters or data that are included in the url of an http request to provide additional information or instructions to the server