With Make.com, you can have data from Keyline written automatically to a Google Sheet, for example.
This lets you analyse the latest data or use it for other purposes.
In our example, you retrieve data for a product that is fully completed and archived.
You then check the Google Sheet to see whether the product is already there. If it is not, you create a new entry for the product and all its components. Otherwise, you update the data.
As you already know from Keyline, Make.com also uses variables. These make formulas easier to build and, above all, easier to read.
The formulas are stored directly in Make.com and then inserted automatically into the connected Google Sheet.
You can therefore build the formulas visually in Make.com and see them directly in Google Sheets, together with the values behind them:
=FEST((7001000120/1000000000)*669;3)
Our example produces a list like this:
