Hello, I’d like to create a Google Spreadsheet/workbook with multiple tabs (er, I guess it’s technically called “Sheet”) that automatically archive (from this time and going forward in the future) certain tweets.
For example, Sheet 1 will auto-archive all tweets that have #hashtagfoo. Sheet 2 will auto-archive all tweets from user:JohnSmithFoo. Sheet 3 will auto-archive all tweets that contain the phrase"foo gardening".
How can I do so?
Please note that it is important that all of these multiple archives be multiple “tabs” in one Google Spreadsheet/workbook. It must not be each archive being its own Google Spreadsheet/workbook.
The columns in each row will contain the following:
Column 1: Twitter user’s username (e.g. @someonefoo)
Column 2: Text of tweet
Column 3: Timestamp of tweet
Column 4: Direct hyperlink to tweet