| A | B | C | |
|---|---|---|---|
1 | TAGS v6.0 | ||
2 | NS - New Sheets Created by mhawksey. Read more about this at: | ||
3 | http://tags.hawksey.info | ||
4 | With this spreadsheet you can: | ||
5 | - automatically pull results from a Twitter Search into a Google Spreadsheet | ||
6 | Instructions: | ||
7 | 1. If not already File > Make a copy this template while logged into your Google account 2. If there is no TAGS menu click this button --> 3. If you've never run TAGS > Setup Twitter Access do so now (this should only need be done once for all your TAGS sheets) | ||
8 | |||
9 | 4. Enter term | iwm.org.uk/collections/item | <- you can use serach operators like AND OR as well as from: and to: eg '#JobsNow AND from:BarackObama' (without quotes) |
10 | |||
11 | 5. Make a one off collection with TAGS > Run now! or set a trigger to collect every hour TAGS > Update archive every hour. To change the frequency open Tools -> Script Editor then Triggers -> Current script's triggers... and adjust | ||
12 | Advanced Settings: | ||
13 | Period | default | |
15 | Follower count filter | 0 | <- if search term is being spammed you can set the minimum followers a person must have to be included in archive |
16 | Number of tweets | 3000 | <- maximum varies based on the type of archive you are collecting |
17 | Type | search/tweets | <- use a search term in step 3 above to get results from last 7 days |
18 | Stats | ||
19 | Number of Tweets | 0 | |
20 | Unique tweets | 0 | |
21 | First Tweet | 08/05/2016 10:24:09 | |
22 | Last Tweet | 17/02/2020 17:23:54 | |
23 | Make interactive | ||
24 | Turn your archive into an interactive online resource using TAGSExplorer - see http://bit.ly/TAGSsetup | ||
25 | Note: File > Publish to the web *and* Share > Anyone with link to use these views | ||
26 | TAGSExplorer | <- conversation explorer | |
27 | |||
28 | TAGS Archive | <- searchable archive | |
29 | |||
30 | News | ||
31 | TAGS v6.0 is here! Includes streamlined twitter connection experience and new support site | ||
32 | http://tags.hawksey.info/ | ||
33 | |||
34 | |||
Loading...