Skip to content

Google Sheet RFM pipeline

Download link for necessary files: GSheet files.

In this tutorial you will learn how to set up a pipeline that retrieves data from a Google Sheet, performs a simple RFM analysis on it, and writes back the result to the Google Sheet.

How does it work?

Step 1: Login to your UbiOps account at and create an API token with project editor admin rights. To do so, click on Permissions in the navigation panel, and then click on API tokens. Click on [+]Add token to create a new token.

Creating an API token

Give your new token a name, save the token in safe place and assign the following roles to the token: project editor. These roles can be assigned on project level.

Step 2: Download the GSheet files folder and open gsheet.ipynb. In the notebook you will find a space to enter your API token and the name of your project in UbiOps. Paste the saved API token in the notebook in the indicated spot and enter the name of the project in your UbiOps environment. This project name can be found in the top of your screen in the WebApp.

Step 3: Run the Jupyter notebook gsheet.ipynb and everything will be automatically deployed to your UbiOps environment! Afterwards you can explore the code in the notebook or explore the application in the WebApp.