Discussion

Streamline your billing process

Instiller records every bit of activity for all of the client accounts that are setup with your solution and that helps you to ensure maximum revenue when invoicing your clients.

On average, each of our Instiller agencies has around 110 client accounts setup in their solution and that results in having to deal with a lot of data when it comes to sending out invoices.

Billing data can be downloaded and we have an API for those pull the information into their systems but with Zapier there’s now a quicker and easier way.

If you’re using Instiller and want to save time with generating invoices whilst ensuring that you achieve maximum revenue at the same time then here’s a quick guide that takes you through setting up sending data to Google Sheets each month.

Get a Zapier account

The first thing you’ll need to do is setup a Zapier account if you don’t already have one.

Their free account is sufficient as that will allow you to run a small number of Zaps each month and there’s more info on the paid plans here.

Create a Zap

This bit is easy, just click the ‘MAKE A ZAP!’ button at the top of the screen when you’re logged into Zapier.

Set the schedule

Zapier has a scheduler app that let’s you run timed processes. In the search box type ‘Schedule by Zapier’ and then click on the result.

Schedule by Zapier

Once you’ve done that go through the next steps but for testing just choose…

  • Every month
  • 1st day of the month
  • 1am

This will fire the scheduler off at 1am in the morning on the 1st day of every month.

Export the Transactions log

To do this you will have already needed to click on the invite link to add the Instiller for Agencies Zapier app to your dashboard.

Type ‘Instiller for Agencies’ in the search box and then click on the result.

Zapier - Instiller for Agencies

Now choose theses options…

  • Export Transactions Log
  • Connect to your Instiller instance (using the URL and Solution Level API Keys)
  • Set ‘Export Type’ to ‘Previous Month’
  • Leave all the other settings as they are

Press the button until you see ‘Add a Step’ and ‘Finish’ – click ‘Add a Step’.

Throw the data into Google Sheets

You’ll need to have created a Google Sheets spreadsheet with one row of column headings. For now, just set two column headings of name and transactions.

The Action you need to choose is hidden in the next step so click on ‘show less common options’ and then click ‘Create Spreadsheet Row(s)’ – this option will create one row for each of your clients.

Click the button to move onto connecting up your Google account and then in the next step choose the spreadsheet and worksheet.

To map the data into the correct columns click the button at the end of each input control in the ‘Rows’ section. From the dropdown that appears click on ‘Export Transactions Log’ and then pick out Company Name for the first column and Total for the other.

Click the continue button and then on finish to give your Zap a name and to turn it on.

Have any questions?

If there’s anything else you’d like to know about using Zapier to improve the management of your email marketing clients then just let us know.

Ready to try Instiller out?

Take a free & unlimited 14 day trial of Instiller and discover
how our solution could work for your agency.

Free trial

There's no commitment and we don't ask for payment details.