Add links to Infusionsoft records in Google Sheet export
Here is a sample of a spreadsheet I made that automatically cleans up records output from IS using the Google Sheets Exporter. This is what I use to quickly run through calls to "opportunities".
https://docs.google.com/spreadsheets/d/15WJZ58fftPo00s8sgsYHIfIKQduo0ZzzI1u0RIyHdiA/edit?usp=sharing
I use a saved search on opportunities to output to the second tab ("Active") and I use the first tab "Links" to clean up the data a bit, mainly the headings and also linkifying the Opportunity name using this formula:
=hyperlink(CONCATENATE("https://APPNAME.infusionsoft.com/Opportunity/manageOpportunity.jsp?view=edit&ID=",Active!A2),Active!B2)
(Of course replacing APPNAME with your app name.)
Any record could be linkified like this.