Description

This activity saves the table in Excel, Google Sheets or CSV format.

A possible usage example is to read a table and save its contents into a different table. This is what this workflow does. Save the previous step result option is used.

This bot reads the table and saves the contents to another table

Parameters

The first parameter is Table. It is required. The table you are going to save is specified here. Note that it does not have Set a value option - it is intended for use either with Calculate a value option where you set the table dynamically or Save the previous step result option which is the most convenient for use with variables.

Table parameter

The Calculate a value option lets you form the value dynamically. Here is a usage example:

{
    "My List": [
        {
           "Country": "Russia",
           "Capital": "Moscow"
        },
        {
           "Country": "USA",
           "Capital": "Washington DC"
        }
    ]
}

"My List" is the table sheet name, "Country" and "Capital" are columns, "Russia", "USA", "Moscow" and "Washington DC" are the respective values that will be written to the columns.

An example of setting up the value using the Calculate a value option

This is how the result would look like.

The new data was written to the Excel file

The next parameter is Save table as. It is required. Here you can choose Excel, Google Sheets or CSV format. Each format has a different set of options.

This is a set of options for Excel format. It is also possible to select a specific table sheet.

Options for Excel format

Options for Google Sheets are different. Also do not forget that it requires a connected Google account. It can be added in 'Settings' - 'Services Connection' menu.

Options for Google Sheets

And here are the options for CSV format. Its unique feature is Delimiter. Commas, semicolons or tabs can be used.

Options for CSV format