-
Log in to the Fracttal One platform and go to the main menu on the top left.
-
Click on the "Automator" module.
-
Select "Fracttal Hub".
-
Click on the "Add" option in the lower right corner.
-
Give a name to your flow configuration.
-
Select "Activator".
-
Choose the type of activator:
-
Event: Activated each time an event occurs.
-
Manual: Triggered only by a manual click.
-
Date: Triggered on a specific date.
-
Frequency: Triggered at programmed time intervals.
-
-
Once the activator has been selected, click on "Save".
-
Select "Source" and specify the module, connection and action: In our example we will work with Google Sheet
-
Module: Select the desired communication type (previously configured in the configuration module), such as Fracttal API, database, email, HTTP request or Google Sheets.
-
Connection: Choose the communication settings previously established (This is previously done from the configuration module).
-
Action: Define the action you want the communication to perform, in this case it is "read".
-
-
Once these options are completed and after selecting Google Sheet, the following fields will be enabled to be filled out
-
spreadsheet_id: Enter the snippet of the Google Sheets link you are working with.
-
Sheet: This field indicates on which sheet the information is located. It is important to remember that the sheet numbering order starts from zero. Therefore, if the sheet is the first one, the number zero must be entered in this space, since zero indicates that it is the first sheet.
-
Campos: Here you should add the names of the different columns you have in your Google Sheets file.
Note: In the image above, we have added these specific fields, as they correspond to the different columns found in our Google Sheets file.
-
-
Click on "Save".
-
In case you want a more precise extraction of information, select "Filter" to set conditions (rules) defining what information you want to extract. If you feel this is not necessary, you can skip this step and continue with the next one.
-
Select "Connection" (Destination).
-
Click on "Module" and select the option you want to connect to send the information. In this example, we choose "Fracttal API", since we want to send the information stored in Google Sheets to Fracttal One.
-
Choose the name of the consumer created earlier from the "Configuration module".
-
Select the action you want to perform. In our example, we want to create assets in Fracttal One using the information extracted from the Google Sheets file.
-
click on save
-
Click on configuration
-
Here you make a presentation of the names you have in the Google Sheet file, with the names belonging to the Fracttal One Software (right column), if you have doubts about the names, you can look up their meaning here: Fracttal API
-
Once the names have been submitted, click on "Save".
-
Finally, enable the created ETL, save the changes and run