← HOME  /  PROJECTS

Taboola API x Google Spreadsheet

Apr. 2024


One of Taboola Japan’s clients approached and asked if there is a way to transfer data to Google Spreadsheets in a quicker manner. Currently, they are transferring data manually by downloading it from the client dashboard and uploading it to Google Drive. However, this did not satisfy the customer. They asked for an easier way to transfer data.

Language, Frameworks, and Tools Used

  • Google Scripts
  • API
  • Google Spreadsheets

    • Requirements

  • While there are third party tools that do the operation, the client wanted to avoid using third party tools due to trust and breach of important data.
  • The client would like data directly delivered from the system in fear of data tampering.
  • On the other hand, they wanted a simple solution. In other words, using Python or Node JS to connect to the dashboard API was not an option as it was too complicated for the client to manage and handle.
  • The programming function should filter out data and then write the important data to a spreadsheet.