ETH price updates sent via @EthereumPrice_ on Twitter are logged and parsed in a Google Sheet with this Applet. This Applet writes the following fields to the spreadsheet: • Timestamp • Tweet Text • Link to Tweet The Applet includes spreadsheet formulae to parse the following data from the tweet text in the columns to the right of the above fields: • Date • Time • Exchange Rate text • ETH→XBT Rate (number only) • ETH→USD Rate (number only) The numbers can be used in calculations directly.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Explore more great ways to automate Twitter and Google Sheets