Infusionsoft Reporting with Google Sheets
Reporting inside of Infusionsoft is one of the single most complained about features. While the reports are mostly adequate, they simply are too limited and not easily customized. There is also no way to create nice visual charts or graphs and delivery of the reports to management can also be “challenging”. Until now…
Introducing, the Google Sheet It Helper for MyFusion Helper! In a hurry? Just watch the video here:
Google Sheets Comes to Infusionsoft
Our philosophy here at MyFusion Solutions is to INTEGRATE and not to reinvent the wheel. Case in point, we could have gone off on a mission to create a complete reporting module for Infusionsoft (others have). But our vision is one of “integration” instead. So we took a different path.
Google Sheets is a terrific reporting mechanism. Often called the “online version of Excel” for its ability to create eye-popping charts, graphs and richly formatted reports, it seemed like a logical fit to integrate with Infusionsoft. So that's exactly what we did.
How it Works
It really is quite simple and you can have your first report up and running in five minutes. Here's the simple four step process to follow:
- Create a saved search or saved report in Infusionsoft and give it a name.
- Using MyFusion Helper, create a simple Google Sheet It Helper that links the report to Google Sheets
- Copy/Paste the provided code from MyFusion Helper into Google Sheets
- (Optional) Set up Google Sheets trigger to automatically refresh the data on your desired cycle.
That's it! Honestly, it takes less than 5 minutes to do. We've also made a video you can watch (above).