Import tabular data from Google Sheets and process it in EasyMorph without scripting.
EasyMorph natively supports data types of Google Sheets, including dates.
Unlike traditional ETL tools, EasyMorph doesn't require columns to be only of one particular data type, which makes EasyMorph a very convenient tool to work with semi-structured data such as spreadsheets.
Export data to Google Sheets from any point in your data preparation workflows.
EasyMorph comes with the "Google Drive command" action that allows uploading and downloading single files and collections of files to and from Google Drive.
EasyMorph comes with a built-in connector for PostgreSQL, MySQL Server and SQL Server, so no additional dirver installation is required.
It also works with ODBC connections, defined in Windows.
Non-technical users can use the visual Query Editor to import data from Google Cloud SQL databases. The queries can have complex filters, groupings, and aggregations. In a similar manner, data can be exported back into a database, without writing SQL statements.
The ODBC connector in EasyMorph has a dialect to with wit Google BigQuery. Use the "Import from database" action import data from BigQuery tables without writing SQL queries.
Use the email connector in EasyMorph to fetch emails from GMail, save attachments, and process them in automatic manner.
Schedule mail retrieval.
Besides retrieving emails, use the "Send email" action to send out templated emails, with attached files, if necessary.