Google Sheets Automation Tools

We’re consistently mind-blown at what can be done with a simple Google Sheet.

Sheets lives at the center of a connected data ecosystem, so it can do pretty much anything that a full-fledged app can.

When combined with a few friends, the Sheet becomes a powerhouse:

1. Add-ons like Supermetrics, to pull marketing data from APIs like Google Analytics
2. Zapier, to send data from and to your other tools
3. Google Apps Script, for in-Sheet automations
4. Data Studio, for sexier visualizations

By combining these tools with advanced Sheets formulas, we’ve created some awesome tools:

• SEO Content Auditing
• Agency Project Management
• Facebook + Instagram Funnel Visualization
• Editorial Calendar Automation

The opportunities are truly endless. And the CIFL team is here to help you automate your way to a more relaxed + productive workflow.

Sample dashboard built to track SEO progress.

What our service entails

We realize this service is a little unorthodox, so let’s talk about what to expect when engaging us.

Step 1: Consultation to determine the best solution

We’ll work with your team through a series of consultations to review roadblocks and bottlenecks at your company. Our team will determine the best solution.

Timeframe – Week 1 of engagement

Step 2: Selection of technology stack

Our team will handle all the technical stuff. We will determine tools, data sources and APIs needed to build your solution (Sheets, Zapier, Supermetrics, etc).

Timeframe – Week 2 of engagement

Step 3: Delivery of spec doc

Before kicking off any work, we fully map out the pieces that’ll in a spec doc (that looks very similar to this one).

Timeframe – Week 2 of engagement

Step 4: First draft of tool and iterations

Depending on the complexity of the build, we will have you a first draft of the tool to review by week 3. We allot a full week of time for revisions.

Timeframe – Weeks 3 and 4 of engagement

Step 5: Completed tool

With your final sign off on the tool, it’s yours to use. Our team makes themselves available for support to ensure it’s adapted into your company’s ecosystem.

Timeframe – Week 5 of engagement

Example spec doc you will receive before the build begins.

How we price custom Sheets templates

Since we know up front exactly what pieces will come together for your workflow, we can quote you a flat rate for the build up-front.

Templates in Sheets and Data Studio are priced based on a point system.

• Each API connection, view (query) of that raw data, or unique report is considered 1 point
• Each point adds $350 to the cost of the template

A typical template, that combines a few data sources in Google Sheets + visualizes it in a Data Studio report, will run from $3-6k.

More complex automation workflows (like Project Management), that involve a lot of custom scripting / passing data between Sheets + tools, will be a bit more expensive.

Let’s dive in

To see if our services are a good fit for your team, please book a time to connect here.

The more info you can provide up-front, in terms of what your team needs out of an end template, the better we’re able to point you in the right direction up front.

Look forward to connecting!