Google Sheets™
9 min
google sheets is one of the most widely used tools for reporting, forecasting, and ad hoc analysis customer success, revenue ops, and leadership teams rely on spreadsheets for qbr decks, board reports, renewal tracking, and account planning customer success managers use google sheets to build custom renewal trackers prepare qbr reports with live customer metrics monitor risk scores across portfolios combine custify data with billing or support data create executive summaries for leadership the custify google sheets integration allows csms to fetch company and people data directly into a spreadsheet using built in formulas no api knowledge required if you can write a basic formula, you can pull custify data working with custify data in google sheets the integration provides direct access to custify company and user attributes within google sheets with this setup, users can retrieve company data such as name, mrr, arr, churn date, and custom attributes access risk score and health score values track contract end dates for renewal management retrieve user level information such as email, last seen, role, and custom fields build dynamic reports using cell references automatically refresh data without requiring manual exports practical examples below are some common use cases where the integration can add value customer risk dashboard display company name, risk score, mrr, and last contact in one live view qbr preparation pull company metrics and contract data into a client ready document renewal tracking track contract end dates, risk, and revenue in one operational sheet executive reporting combine custify metrics with finance data to build board ready dashboards account planning maintain account plans that automatically update with the latest custify data churn analysis pull churned at and churn reason attributes to analyze lost accounts how does the integration work? the integration works through custom spreadsheet formulas that retrieve data from your custify account available functions include custify company data fetches any company attribute using the company id example \=custify company data("comp abc123", "mrr") custify people data fetches any user attribute using the user id example \=custify people data("user xyz789", "email") custify people data by email fetches user attributes using an email address example \=custify people data by email("john\@example com", "last seen") you can use standard attributes like name, mrr, arr, created at custom attributes via dot notation, such as c ustom attributes plan type health scores using the metrics health scores structure risk score via custom attributes riskscore custify data is cached for 30 minutes to reduce api calls and improve performance users can click “refresh all data” anytime to pull the latest information each user authenticates with their own api key data is not shared externally how to activate the integration? open google sheets go to extensions > add ons > get add ons search for custify integration click install and grant permissions the app can be installed directly from the https //workspace google com/marketplace/app/custify integration/60575592701 after installation open a spreadsheet click custify in the top menu select configure api enter your custify api key from settings > developer > api keys enter your base url, usually https //api custify com save and start using formulas
