So #OSINT folks also wanted to see a streaming sample, which is not great for @zapier so we need to get a little creative with Google Sheets and a bit of code.
Goal: Multiple journalists working together with @hunchly in automatic capture mode.
1.1/n
Today we'll cover how to stream multiple Hunchly users into a single Google Sheet. In another thread I'll cover how to get reaaaaaal fancy! No servers or software to install but some code to copy and paste.
1.2/n
Create a new Google Sheet, name it ADVANCED_JOURNALISM_TEMPLATE and create two sheets: URL History and Selectors as shown:
2/n
Click the Tools menu and select Script Editor.
3/n
A lot of Stackoverflow articles and other resources online will reference the old legacy editor so to save you some headache in advance click: Use Legacy Editor
Click the Publish menu and then select "Deploy as web app".
6/n
In the new window you fill out the boxes as shown. Note we are NOT securing this, we are assuming a breaking story with a tight team of journalists. Govern your own selves accordingly here or read the Google docs on securing web apps.
Click the Deploy button.
7/n
You will be prompted to review permissions, click the "Review Permissions" button.
8/n
You will walk through approving your own app to access your account. You may have seen a similar dialog before!
This is not permitting us @hunchly to access anything, you are just authorizing your own web app to use your own Google account.
9/n
Well holy shit, you just deployed a Google app! *slow clap* Nice work! You will be presented with a dialog that contains your URL for the web app.
Copy and paste it into your browser to see how your doGet() function returns "OK!" to your browser. Neat right?
10/n
Switch to your Hunchly Dashboard and in the data forwarder settings you want to paste your Google Web App URL directly into the HTTPS address and click Save.
11/n
If you haven't already setup new case information fields. Add two fields: Journalist and Email
These should be filled with your name and email address so other team members know how to reach you.
11.1/n
Start browsing! Hunchly will stream pages at your little web app merrily from all team members, creating a shared URL history.
In my next post let's see what other crazy stuff we can do with Google AppScript (I actually don't know, I'm learning as we go here).
Well this is fucked but let me tell you, this is only the tip of the iceberg with @SaskatoonPolice Looks like me and my team gotta add another name to the list to deal with ourselves *clicks new case* so be it.
You realize that Doug Mouser's case comes from #yxe right? Anyone?
I mean, the last two years anyone been wondering where all of these cases come from I am talking about?
How did I find Doug Mouser's case? Like the journalists are so fucking bad in this city it's hilarious. They are as shitty as the police.
Allow me to draw you a diagram some day. But let me assure you the ATIP team at SPS know me very well at this point. As does the Privacy Commissioner. And the Chief. And pathologists.
Y'all been asleep at the wheel in this city from the Mayor's office, the police, the media...
Seriously, people, if you're posting media from Ukraine (or anywhere else) and it contains graphic imagery there's no excuse for not putting a content warning on it. Stop forcing people to see graphic imagery without their consent. A how-to 🧵 1/5
Alright time for another @hunchly thread. This will show you how to setup a YouTube downloading data forwarder on your local machine with just a little #Python
How can Hunchly be used by journalists during a breaking story to collaborate in Google Drive or Sheets because every newsroom has it?
Let me show you how I made the following:
Today we'll cover codeless (but not free) Hunchly data forwarding with @zapier This will demonstrate how a team of freelance journalists, or a newsroom could have a quick shared Google Spreadsheet of interesting URLs that team members are finding. Read on!
1/n
Sign up for a Zapier.com account, you *will* need a premium account. Codeless does mean costless :) We'll cover some free alternatives another day, but then you gotta code.
2/n
We would love our #OSINT and #cybersecurity folks to go grab it and read on below: 1/n
What is it and what is it not? Hunchly Mobile is not the same as Hunchly Desktop. It does *not* do browser capture but what it provides is a way for you to drop files, recorded videos or any other mobile-only content into Hunchly and to annotate them for context. 2/n
Hunchly automatically hashes the files and puts them in a case, just like you would expect. When you are done? Export the mobile case and it provides a handy HTML report with your files, and annotations waiting for review. You can import the zip file into Hunchly Desktop.