Replicate Google Sheet IMPORTXML tool using BaseRow & AWS Lambda: A Case Study

IMPORTXML tool is a fantastic feature of Google Sheets that allows you to crawl and parse data. However, it has a few limits on the parser or performance. That’s why our client, with their extended requirement on the number of records, the complexity of the parsing script, and the situations of error handling, wants to build that utility without changing the user experience.

Learn more about our AWS Lambda & Serverless Development.

Features

• Extend baserow.io as the data editor; this software can replicate Google Sheet features.
• Replicate almost exactly Google Sheet IMPORTXML with extensive technical specs.
• Extend IMPORTXML features with columns for status tracking and error tracking.

Challenges

• It challenges our learning by reading and extending baserow.io.
• Data scraping in AWS Lambda is a challenge as well. It requires things to be minimized to save resources.

Learn more about our Custom Software Development.