Step-by-Step Walkthrough: How to connect Chargebee to Google Sheets?
Here’s a step-by-step overview of how to connect StackIt to Google Sheets using StackIt’s new connector.
Step 1: Click Extensions from the Google Sheets menu. Select Add-ons and choose to Get Add-ons. This will bring you to the Google Workspace Marketplace.
Step 2: Look for StackIt in the Google Marketplace pop-up window and install the app by following the prompts.
Step 3: Once you are on Google Sheets, go to the Extensions tab, you will see StackIt there. Launch StackIt from there.
If StackIt is not visible, wait for 10 seconds for Google Sheets to load completely.
You should see StackIt running as a Google Sheets side panel on the right side of your screen. Click on "Connect your first source"
Step 4: Select Chargebee from the list of data sources.
Step 5: Go through all the directions and prompts to connect your Chargebee account to Google Sheets.
Step 6: Now select the objects from the list you want to import from. Let's say we want Subscription data.
Step 7: When you click Import, the data you want to export from Chargebee should auto-populate your Google spreadsheet like this:
Step 8: StackIt lets you refresh your imported data instantly with one click or set it to auto-refresh on a pre-set schedule.
This way, you won’t need to manually update your Chargebee data in Google Sheets to reflect changes from the source.
Voila, you've successfully imported your Chargebee data to Google Sheets!