
How this automation works
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.
New tweet by a specific user
Trigger ingredients
Add row to spreadsheet
Action fields
Services used in this Applet
You might also like...
-
Tweet your Instagrams as native photos on Twitter
-
Sync all your new iOS Contacts to a Google Spreadsheet
-
Log how much time you spend at specific locations like the office or home in a spreadsheet
Create your own X (Twitter) and Google Sheets workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
24 triggers, queries, and actions
Build an automation in seconds!
You can add delays, queries, and more actions in the next step!
More on X (Twitter) and Google Sheets
About X (Twitter)
X (Twitter) Applets can help you manage and save tweets, keep an eye on #hashtags, and much more.
X (Twitter) Applets can help you manage and save tweets, keep an eye on #hashtags, and much more.
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.