One of the big advantages of spreadsheets is that you can use them as real data sources to search or display information.
E.g.: manage a price list and display the right amount according to the customer's profile.
In order to setup your Data source, open the configuration window and move to Data source tab.
You have 2 options for your data source :
1/ Manual
You enter information directly in the Spreadsheet or copy/paste it from an exernal list
2/ Remote
Your data is fetched from an external source such as an API or a public CSV
Field | Explanation | Examples |
URL | Url of the remote API or web service to use | |
Data format | Format of data that will be returned | JSON, CSV |
Path to data | Only if Data format is json.
Path to the actual data within the json content | data, data.users, data.user.books |
Load data automatically | Check if you want the data to be automatically updated once per day |
Once the information has been enetered or fetched, you can use dedicated spreadsheet mergeds tags to access your data in your procedures.