7 Steps to Instantly get your ActionSprout signups into a Google Spreadsheet

ActionSprout to Google Spreadsheet

About ActionSprout

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.
ActionSprout Blog 1

2. Copy the Web Hook URL given to you by Zapier to your clipboard (ctrl + c).
ActionSprout Blog 2

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.
2014-05-02 14-25-32

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:

  • ID
  • LANGUAGE
  • ACTION TITLE
  • DESCRIPTION
  • CONTACT ID
  • PHONE
  • EMAIL
  • ADDRESS
  • STATE
  • POST CODE
  • COUNTRY
  • NAME
  • FIRST_NAME
  • LAST_NAME
  • FB_URL

Now add a sample row to your spreadsheet (this is required or else the zap won’t work). Your spreadsheet should look like this:
ActionSprout Blog 4

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.
ActionSprout Blog 7

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:

ActionSprout Blog 5
ActionSprout Blog 6

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 🙂

2 thoughts on “7 Steps to Instantly get your ActionSprout signups into a Google Spreadsheet

  1. Alexey Kiselev

    Hi! We had to move to paid Zapier account as free plan is limited not only by “Zaps” but also by triggers it sends to Google docs. It is only 100 for free account. Or I wrongly understood the free plan? Could you please comment on it. 15 dollars not a big sum but we dont want to put collected data at risk.

    Reply
    1. mike031@gmail.com Post author

      Hi Alexey, I was not aware of the limit on triggers. That is interesting to know thanks. I upgraded to the paid account version a while ago, so must of missed the 100 trigger limit. I found Zapier to be extremely helpful for many things and love the tool so far. I would highly recommend looking into the other possibilities by visiting the Zapier website and viewing the list of supported platforms as well. I have coupled Zapier with a dash board platform called Geckoboard to create nice real time Digital Marketing dashboards.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *