How to pass data from Ruler Analytics into a Google Sheets using our Zapier Integration.
With our Integration with Zapier, one of the apps we can connect to is Google Sheets.
We have found that many of our clients use Zapier to pass data from Ruler Analytics into a Google Sheets for many reasons. It is one of our most popular integrations and really easy to set up.
Why would I want to push my data from Ruler Analytics to a Google Sheet?
Pushing your data into Google Sheets allows you to create a weekly / monthly report of all your calls and conversions along with the marketing source and keyword that drove the interaction.
We find our agency partners find this Zap particularly useful as it allows them to share data with their clients daily and show how the true impact of their work.
How do I get started?
To get started with this Zap you will first need to create a Zapier account. Check out our guide on how to create a Zapier account and connect your Ruler account here -
Create a Sheet
First, you will want to create a new sheet to store your information from Ruler Analytics.
You will want to create the headers to display the variables you want to push through from Ruler Analytics. Take a look at an example template below;
Make a New Zap
Once you have connected your Ruler Analytics account to your Zapier and started to create your first Zap, you will be asked to select a Trigger App. This will be Ruler Analytics.
There are 3 main elements of Ruler that you can push into your other products, These are a New Conversion, a New call and a New Company visitor.
For this example, we have selected a ‘New Call’.
Once you have selected the trigger you will then be asked to choose your ‘Action App’. This is the app that will display the data you are collecting from Ruler.
Follow the steps below to create your first Google Sheets Zap.
For Google sheets, there are 3 actions to choose from when sending data from Ruler. You can choose to either create a spreadsheet row, update a spreadsheet row or do a search for an existing row in a sheet and update it with more values.
For this example, we are going to ‘create a new spreadsheet row’.
Once you have connected the spreadsheet you want the Zaps to pass through to, you will see all the available columns in your spreadsheet. You will then have to map the available variables from Ruler to each column in your Google Sheet.
You can then save and send a test to your Google Sheet to ensure the Zap is working as expected, this should show up within 5 minutes.
If you have any questions about this Zap or any of our Zapier Integrations please let us know.