I want to create a Google Data studio dashboard from Infusion soft data. The main problem are the connectors - there are multiple tools that provide direct connectors but they are paid solutions like Klipfolio, Clicdata, Grow etc.
If a direct connection is not possible, I want to use some combination of Google sheets and Zapier or other free tools to create a data flow that can be constantly refreshed for data coming in from "infusionsoft" to "Google data studio"
- Is there any direct way of connecting Infusionsoft data or API with Google data studio (maybe with some Database like MySQL/postgresql/cloud sql etc?)
- What are some free mid-tier tools I can use to create this data connection?(Zapier, google sheets, excel etc)
All your suggestions are highly appreciated.