Are you tired of looking for ways to add Google Sheets Rows for new Chargebee Subscriptions?

How to Add Google Sheets Rows for New Chargebee Subscriptions

If yes, then you’ve come to the right place. As, here in this blog, you will get a step by step guide to add Google Sheets Rows for new Chargebee Subscriptions automatically. Hence, you don’t have to worry about doing redundant work & can ultimately save a lot of time and effort.

Now, here comes a question that how you can integrate Chargebee with Google Sheets? Well, the answer is quite simple and that is known as Pabbly Connect.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect 

Pabbly Connect is one of the best integration & automation software available in the market which helps you to integrate several applications, set unlimited triggers & actions, create infinite workflows, etc. And, to do so, you don’t even require any coding skills. Just integrate it once & relax, it will handle all the workload afterward. Furthermore, you can access all the features even in its free plan.

So, without wasting any more time, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Start the process to add new Chargebee subscriptions to Google Sheets rows by pressing on the “Sign Up Free” icon on the Pabbly Connect home page. Following that, you can either manually fill-up all the details or sign up using your Gmail account.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Subsequently, after logging into the account, press the “Access Now” button of the Connect section in the dashboard.

Step 3: Workflow for Chargebee with Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow for your project by pressing the ‘Create Workflow’ button.

(b) Name the Workflow

Name the Workflow for Chargebee to Google Sheets

Now, it’s time to name the workflow just like in the above-shown image. I named the workflow as “Chargebee to Google Sheets”, you can obviously name the workflow as per your needs.

Step 4: Setting Trigger for Chargebee with Google Sheets Integration

After naming your workflow, now select the application you want to integrate. Pabbly Connect allows you to integrate unlimited premium applications, create your free account now.

(a) Select Application you Want to Integrate

Select Chargebee to Add Google Sheets Rows for New Chargebee Subscriptions

Now, select the application that you want to integrate. In this case, we are choosing “Chargebee” for integration. And, in the method section, select “New Subscription”.

(b) Click on Connect Button

Click Connect Chargebee

After that, now you have to press the “Connect with Chargebee” button just like in the above-shown image to take further the integration process.

Step 5: Connecting Chargebee to Pabbly Connect

Moreover, in order to connect Chargebee with Pabbly Connect, you have to add the API key and site name in the software. Hence to do that, you have to first log in to your Chargebee account.

(a) Click on Chargebee Settings

Click Settings Chargebee to Add Google Sheets Rows for New Chargebee Subscriptions

Once you log into your Chargebee account, hit the “Settings” option, & then press the “Configure Chargebee” option.

(b) Click on the API Keys

Click API Keys Chargebee

Consequently, now you need to scroll down the page and press the “API Keys” option to proceed further.

(c) Copy the API Key

Copy the API Key Chargebee

Now, simply copy the given API key, or else you can generate a new API key by pressing the “Add API Key” button.

(d) Paste the API Key

Paste the Credentials

After copying the API key, now you have to paste it into the Pabbly Connect dashboard. You can find the Chargebee site name from the subdomain of your Chargebee account. Once, you are done pasting all the required details, then click on the “Save” button.

Step 6: Add a Sample Subscriber

Subsequently, in order to check this integration, we have to send a test request and for that, we will create a dummy subscriber on Chargebee.

(a) Click on Subscriptions

Click on Subscriptions Chargebee

Hence, to add a subscriber, first of all, you need to press the “Subscriptions” option in your Chargebee dashboard.

(b) Click on Create Subscription

Click on Create Subscription Chargebee

Once you reach the subscription page, just press the “Create Subscription” button in order to add a new subscriber.

(c) Add Details

Add Details

In this step, you have to enter all the required details of the subscriber such as name, company, email, etc.

(d) Create Subscription

Click on Start Subscription

Subsequently, after entering all the details, just hit the “Create Subscription” button.

(e) Send a Test Request

Send Test Request

After adding a new subscriber in Chargebee, capture the data by pressing the “Save & Send Test Request” button in Pabbly Connect dashboard.

Step 7: Test the Response in Pabbly Connect Dashboard

Save the API Response

Furthermore, after pressing the “Save & Send Test Request” in Pabbly Connect, the subscriber info will appear on the Pabbly Connect dashboard. Later on, just hit on the “Save” option.

Step 8: Setting Action for Chargebee with Google Sheets Integration

Consequently, in order to make this Chargebee and Google Sheets integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate to Add Google Sheets Rows for New Chargebee Subscriptions

Next, hit the “(+)” icon then select “Google Sheets” and in the choose method option, select ” Add New Row”. After that, press the button named “Connect” to authorize it with Google account.

(b) Click the Connect Button

Click the Connect Button to Add Google Sheets Rows for New Chargebee Subscriptions

After pressing the “Connected with Google Sheets” button, an authorization window will open up, so that you log in to your Google account.

(c) Map Field Data

Map Field Data to Add Google Sheets Rows for New Chargebee Subscriptions

All the sheets in your account will appear on the dropdown. Just select the sheet, which in our case is “Sheet1”. Now, all you have to do is add the necessary field from the drop-down like for the name, select the name option, and for the email field select the email. Then, map all the other data in the same way. Succeedingly, just click on “Save & Send Test Request” button.

Step 9: Test the Submission and Save

Test the Submission and Save to Add Google Sheets Rows for New Chargebee Subscriptions

Afterward, once you hit the “Send Test Request”, all the entries will be sent to Google Sheets Rows. Simply tap on the “Save” button to save the entire workflow.

Step 10: Check Response in Google Sheets

Check Response in Google Sheet to Add Google Sheets Rows for New Chargebee Subscriptions

Finally, when you check the Google Sheets, the entered details get auto-populated in a sheet.

Conclusion –

Hopefully, now you know how to add Google Sheets Rows for new Chargebee Subscriptions in real-time. All you have to do is follow all the above-mentioned steps and you can connect Chargebee to Google Sheets quickly. This is a one-time process, after this one can easily avoid repetitive work with the help of automation by using software like Pabbly Connect that allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like to Read –