The Etlworks Integrator can read and write data in Google Sheets.
What can you do with Google Sheets in Etlworks Integrator
|
Extract data from Google Sheets You can extract data from Google Sheets through four easy steps. |
Load data in Google Sheets You can load data in Google Sheets through only four steps. |
Videos
|
How to extract data from business application or well-known API and load into database
|
Related resources
|
Read from and write into different worksheets using the same Google Sheets connection In the Etlworks Integrator, the name or index of the Google Sheets worksheet is configured in the Google Sheets Connection. |
Google Sheets connector To work with Google Sheets, you will need to create a Connection. In the |
Related case study
|
Fitness club Share data with Tableau using Google Sheets.
|
"Since the Tableau can access the Google worksheet, it was decided to create a Flow that extracts the data from Sage300 API and loads it into the shared Google worksheet." |
Connect to Google Sheets
Read how to create a Connection for Google Sheets.
Extract and load data in Google Sheets
Extract data from Google Sheets
Here are the steps to extract data from Google Sheets.
Step 1. Create a Google Sheets Connection.
Step 2. Create a destination Connection.
Step 3. Create an extract and load Flow. Start by typing in well-known api to.
Step 4. Add source-to-destination transformation where the source is a Google Sheets Connection created in step 1, and the destination is a Connection created in step 2.
When configuring FROM, you can optionally add |worksheetname to the FROM field. It will allow the transformation to read data from the specific Google Sheets worksheet using the same source Connection.
Load data in Google Sheets
Here are the steps to load data in Google Sheets.
Step 1. Create a source Connection.
Step 2. Create a Google Sheets Connection.
Step 3. Create an extract and load Flow. Start by typing in to well-known api.
Step 4. Add source-to-destination transformation where the source is a Connection created in step 1 and the destination is a Google Sheets Connection created in step 2.
When configuring TO, you can optionally add |worksheetname to the TO field. It will allow the transformation to write data into the specific Google Sheets worksheet using the same source Connection.
Comments
0 comments
Please sign in to leave a comment.