{"id":3263,"date":"2024-05-08T12:22:15","date_gmt":"2024-05-08T09:22:15","guid":{"rendered":"https:\/\/docs.cpaas.mittoapi.net\/?page_id=3263"},"modified":"2025-02-06T11:38:47","modified_gmt":"2025-02-06T08:38:47","slug":"connectors","status":"publish","type":"page","link":"https:\/\/docs.cpaas.mittoapi.net\/?page_id=3263","title":{"rendered":"Connectors"},"content":{"rendered":"\n

In order to provide applications with access to your Google Spreadsheet, email via SMTP, you first need to create the appropriate connector, and then connect it to the script.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

You can do this by clicking the \u2018+Add\u2019 button in the \u2018Connectors\u2019 tab on the left side of your personal account page.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Google Sheets-connector<\/h2>\n\n\n\n

In the opened tab enter a name to your connector, comments (if needed) and in the drop-down list \u2018Connector type\u2019 choose the \u2018Google Sheets-connector\u2019 option.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Then insert this part of the link to the \u2018Spread Sheet ID\u2019 field:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

After you can enter the name of the sheet that you will work with into the \u2018Sheet ID\u2019 field, for instance, \u2018Sheet1\u2019:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Click the save button. This way you can create a connector to your Google Sheets.<\/p>\n\n\n\n

If you don\u2019t have a link to your Google Sheet, you can find it there:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Note that everyone who has the link should also has rights to edit sheets:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Now, to use the connector, go to the «Google Sheets<\/a>» and where the properties of the block itself and the supported operations are shown.<\/p>\n\n\n\n

SMTP-connector<\/h2>\n\n\n\n

Fill out the newly opened form with the necessary data for the new connector:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Fill in the following mandatory fields (according to your email service provider’s documentation):<\/p>\n\n\n\n