ActionSprout is a fantastic tool and the results have been great so far for organisations that I have worked with. ActionSprout allows Facebook page owners to know their supporters better which allows them to engage with them better.
With ActionSprout, you are able to get petition signups from Facebook users with just one click or so. You get lots of juicy information like the email address, Facebook User ID and username. The data is then captured into small databases for each ‘Action’ and this can be exported from the ActionSprout interface as a csv file. This is fantastic as you can then import this data into your CRM, email system, or where ever you might keep your supporter data.
There is one really annoying problem though…
Exporting these lists one-by-one and ensuring that they are added to your database in a timely manner can be dreadfully time consuming and there is room for human error at each step. You also probably will need to reformat the exported file to suit your database and doing this every time you want to do an import might make you want to quit your job.
I have a quick solution. It’s not perfect, but it will solve the following issues:
- Having to log in, find the correct, actions, click export, download the file from your email
- Rearrange the export file in Excel: add fields, rename fields, delete data, etc
- Managing importing: Remembering when the last import was done, which actions, etc
- No centralised place for all Actionsprout data
The power and convenience of Zapier
Zapier is a great service for connecting different platforms and moving data from one place to another on a routine basis. You can create a free account and have up to 5 ‘Zaps’ live until you will need to get a paid account.
Here is how to get your ActionSprout data in 7 few steps
1. Log into Zapier and create a new Zap with ‘Web Hook’ as the trigger. Choose Google Docs under ‘Do This’ and ‘Create Spreadsheet Row’ as the action.
3. Open a new tab in your browser and log in to ActionSprout. Navigate to ‘Services’ in the left tab and paste your Web Hooks url into the Web Hooks widget and click save.
4. You will need to have a Google Spreadsheet ready for Zapier before you can tell Zapier where to put the data from ActionSprout. Log into your Google Drive account, create a new Spreadsheet called something like ‘ActionSprout Data’. You will need to specify the column headings in your sheet of the data you want to have in this spreadsheet now. Create the following headings for each column in the spreadsheet:
- ACTION TITLE
- CONTACT ID
- POST CODE
5. Now ActionSprout will send the triggers your Zap. Lets go back to the Zap in Zapier… Select your Google Docs account from the drop down. If you haven’t connected your Zapier account to Google Spreadsheets yet, go ahead and do this.
6. In Step 4 of the Zap set up you can add Filters to the data added. You don’t have to worry about this now. Proceed to step 5 in the Zap set up where you will need to ‘Match up Web Hook Hook to Google Docs Spreadsheet Row’. Go ahead and match the headers like so:
7. Now you can test this zap by clicking the ‘Test Web Hook Trigger’ button in step 6 of Zapier and then click on ‘Test Zap with this sample’ in sample 1. This should now send an example of the latest Action signer to your Google Spreadsheet called ActionSprout Data. Note: If Zapier is having problems getting the trigger from ActionSprout, you need to go ahead and sign the action to trigger a new contact at the stage when Zapier is looking for the trigger.
That’s it! Go ahead and name your Zap and turn it on. Now every time a person signs a Action, a new row will be added to your spreadsheet with the contacts details. Now you can do some reporting, export the spreadsheet when you need to add the data to your database, etc.
Happy Zapping 🙂