Overview
The native Google Sheets integration in Valuecase enables you to create an interactive calculator in minutes. Our customers use this integration to show pricing or ROI calculations. You can specify which inputs your prospects will be able to adjust, which outputs will be shown, and fully customize the calculation through Google Sheets.
How to use
View a Google Sheet in Valuecase
- Create or access the Google Sheet you wish to embed.
- Open the sheet, click on the "Share" button in the top right corner.
- Under general access select the setting "Anyone with the link" and copy the link.
- In Valuecase, add or select a content block, then click the button "+ add media item" in the left sidebar
- In the Add file popup, open the embed drop down and select Google Drive.
- Paste the Google Sheets link into the input field and click "Insert".
Use Google Sheet for calculations
Follow these simple steps to utilize the Google Sheets interactive calculator in Valuecase:
- Click the blue "+" button in the sidebar and select the "Interactive Calculator Block" to add a new block.
- In the sidebar, click "Open" to access the linked Google Sheet, where you can create the underlying calculation logic.
Google Sheet Tabs to Adjust:
- Input: Define input parameters, including pages, line items, units, and descriptions. Enable drop-down answers to provide additional context to your buyers.
- Calculations: Manipulate the inputs using formulas and other Google Sheets capabilities to build the calculation logic.
- Output: Link the calculation results to the value column, and customize their display with adjustments to type, title, description, and units.
- Navigate back to Valuecase and click "Refresh" in the sidebar to update the interactive calculator block with the adjusted data.
- The results will be recalculated and appear in the block, showcasing the value of your solution to the buyer. Adjust the inputs as often as needed to personalize the calculations.
With the Google Sheets integration, the interactive calculator block transforms your Valuecase spaces into a powerful tool for value-based selling and data-driven decision-making. Watch our Loom video for a visual explanation of the Valuecase <> Google Sheets mapping for more information.
For more detailed instructions, including a video walkthrough also check out our Interactive Calculator guide.
