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

IMPORTXML is an amazing feature of Google Sheets that allows you to crawl and parse data. But it has a few limits on the parser or performance. That’s the reason 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 is a software that 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 still 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.