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
Start a new Zap and name it Hunchly Data Forwarder as shown:
3/n
Search for "webhook" or click the webhook button. Click the "Webhooks by Zapier" in the search results.
4/n
Set the Trigger Event to: Catch Hook and click Continue.
5/n
Now you will see your webhook URL, this is where we will point Hunchly. So click the Copy button and open the Hunchly dashboard.
6/n
First we will set up a couple of case information fields so that the Google sheet we are writing to will include journalist's names and email addresses. Click your Settings icon in Hunchly. In the Case Information section click Add and add two new case information fields.
7/n
Now we are going to paste our Zapier webhook URL into Hunchly's settings in the Data Forwarding section:
8/n
Go back to Zapier and click Continue. It will ask you to test your trigger.
I recommend disabling Hunchly automatic capture in the Chrome extension, and then Google or browse to a *new* page and right-click -> Capture. This should trigger sending a hook to Zapier.
9/n
In Zapier click Test & Continue you should see your Hunchly page data showing up in Zapier. Neat right?
10/n
Cool, now we just want to jam it into Google sheets. In your next Zap step, search for Google Sheets and select Action Event to be "Create Spreadsheet Row"
11/n
(I just spent 10 secs clicking on a screenshot of the previous Tweet instead of Zapier itself. Just thought I would share that with you. *clears throat*)
Where was I....
12/n
You have to authenticate your Google account, and select the Drive and Sheet that you want to use.
I recommend just creating new Google Sheet called JOURNALIST_TEMPLATE and have it with the columns: Date, URL, Title, Journalist, Email
Name the sheet URL History 13/n
Back in Zapier make sure everything is configured as shown (yours may be slightly different but should largely look the same as mine). Click the Refresh Fields button and you should be presented with fields for your columns that we can map to our Hunchly data.
14/n
Click each field (Date, URL, Title, Journalist, Email) and then you use the little search bar to find the corresponding information in the Hunchly data. Look at the following screenshots. Slap that Continue button.
15/n
You're done! Click Turn on Zap.
You can now send your colleagues the following instructions:
1. The zapier webhook URL goes in the Hunchly data forwarder.
2. Create two new Case Information fields in Hunchly: Journalist and Email. Fill them in.
16/n
3. Turn Hunchly auto-capture off. Otherwise you will swamp the Zap and your account will be maxed out until next month. You've been warned.
As all of you work on a story, your shared history and who logged it will show up in that sheet.
17/n
*gasps for air*
Note that it is up to you, the gods of security and whatever accounts you have setup to ensure this shared sheet doesn't get abused :)
More to come with some of these fun little things you can do with Hunchly, data forwarding and some creatitivity. #OSINT <fin>
• • •
Missing some Tweet in this thread? You can try to
force a refresh
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.
Hey #infosec and #osint people, I have taken a few calls from cyberstalking/harassment victims in the last two weeks.
Does anyone have free/non-profit resources for people who are survivors of abuse, and are dealing with cyberstalking? List them below if possible? Thanks.
No shitting you got another one today after this was posted. Thank you! Keep them coming, someone is compiling them all and will put up a page somewhere. I think most PI or investigations firms should get the URL too so they don’t turn someone away due to finances that need help.