Google Sheet IMPORTXML Tool: Case Study HDWEBSOFT is a case study by HDWEBSOFT. Industry: Technology. Services provided: Development, Infrastructure Management. Technologies used: AWS, Python. Solutions: Productivity Software, Web Portals. This project uses AWS Lambda over baserow.io to replicate the IMPORTXML tool, an amazing feature of Google Sheets.

TechnologyAWSPython

Google Sheet IMPORTXML Tool: Case Study HDWEBSOFT

This is an interesting project. It's not a big or long term one but it shows all of our best skills in Custom Software Development.

Industry
Technology
Stack
AWS, Python

Product gallery

These screenshots show key user flows, main features, and interface patterns from this project.

Lightbox image

Google Sheet IMPORTXML Tool: Case Study HDWEBSOFT

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.

More case studies

A developer tracking and reporting application
Technology

A developer tracking and reporting application

This application helps you to generate performance reports of your developers by collecting data from GIT or development tracking systems and put them in one place.
A web and mobile conference call using Asterisk and WebRTC
Technology

A web and mobile conference call using Asterisk and WebRTC

This is an amazing web and mobile conference call startup. Anyone can join the call via Web Browsers or from their Cell Phones.
Transforming Workspace Management with a Centralized Desk and Room Booking Solution
Technology

Transforming Workspace Management with a Centralized Desk and Room Booking Solution

A centralized, user-friendly room booking system that not only simplified desk and meeting room reservations but also optimized workspace utilization, empowered smarter decision-making through real-time analytics, and ultimately supported a more agile, productive working environment.
Building CRM with PHP Laravel: A Case Study
Technology

Building CRM with PHP Laravel: A Case Study

HDWEBSOFT built a PHP Laravel SaaS CRM for a Thai client with multi-tenant architecture, billing, lead management, and multi-site deployment.
A platform for education, training and communities
Education

A platform for education, training and communities

The world’s most advanced ecosystem for systemic change.
Raspberry Development for Screen Ad Management System
Media & Entertainment

Raspberry Development for Screen Ad Management System

Our cloud-based digital signage software provides you with the ability to remotely manage and showcase your digital content on any display, from anywhere in the world. You can create and publish content in seconds, so your screens will always be up to date.