Use Cases arrow_right_alt Google Sheets

Process data in Google Sheets

Overview

Problem


Google Sheets makes it easy to edit and share data. However, writing custom code to process this data is not quite as simple. Although there are many excellent Python and Javascript libraries for processing and visualizing data, such as Pandas, Bokeh, and D3.js, it’s not straightforward to apply these libraries directly to data in Google Sheets.

How Flex.io Helps


Flex.io cuts the work needed to create serverless functions for Google Sheets, including handling OAuth refresh tokens and maintaining data connections. As a result, you can focus on coding clear and compact data processing functions and deploy them quickly without a lot of overhead or setup.

Libraries

  • csv-parse
  • Pandas
  • PapaParse
  • agate
  • openpyxl