Version 3.0.1 by WSO2Category : Productivity Tools Supported Product Version : EI 7.0.x EI 6.6.0 EI 6.5.0 Supported Google Spreadsheet API Version : v4
The ability to collect, track, organize, analyze, and collaborate organizational data is critical for any business. Integrating Google spreadsheets with customer relationship management (CRM), landing pages, and forms makes collaboration easy and helps automate business processes such as subscribers sync and marketing workflows.
The Google Spreadsheets connector provides instant API connectivity to the Google Spreadsheets API, allowing applications to access, create, and modify Google Spreadsheets using OAuth2 for authentication.
For example, let’s assume that a customer has to give the name and email to download a product from a company website and the company stores the customer’s data in a Google spreadsheet. The company can later use the Google Spreadsheet connector to read through the spreadsheet and pick the product name, email address, and the name of the customer. It can then use the Gmail connector to send a customized email to the customer.