Hi I am trying to learn / create some reporting automation between infusionsoft and google sheet.
Basicly pulling contacts added in a month, total contacts ectra.
Seems like this would be more of a manual task, rather than automated.
Export data from Infusionsoft.
Analyze data in GSheets via formulas.
One option might be to explore creating a saved search for contacts added in the last week, have it emailed weekly, then parse the email for responses, and push to SheetsI know you requested a monthly report but I think Infusionsoft can only be set up to email reports weekly. https://help.infusionsoft.com/help/search-by-date-created
Another that is closer to what you are wanting is to use the “List Contacts” endpoint.
order the above by the “date created” created field and then do some parsing of the response and voila! This would definitely be an advanced solution though. If you’re not comfortable implementing it yourself, I would love the opportunity to help build you a custom solution.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.