Portia vs Sheetsu

Overview

Sheetsu

Stacks17

Followers91

Votes8

Portia

Stacks26

Followers66

Votes0

GitHub Stars9.5K

Forks1.4K

Portia vs Sheetsu: What are the differences?

What is Portia? Visual web scraping tool that lets you extract data without writing a single line of code. Portia is an open source tool that lets you get data from websites. It facilitates and automates the process of data extraction. This visual web scraper works straight from your browser, so you don't need to download or install anything.

What is Sheetsu? Turn a Google Spreadsheet into an API. Use spreadsheet as your database. Give data to your users the nice way, directly from the tool you know. Without bothering webdeveloper.

Portia can be classified as a tool in the "Web Scraping API" category, while Sheetsu is grouped under "Spreadsheets as a Backend".

Portia is an open source tool with 7.08K GitHub stars and 1.12K GitHub forks. Here's a link to Portia's open source repository on GitHub.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Advice on Sheetsu, Portia

DetStartups

Nov 11, 2019

Needs advice

I'm trying to set up an ideally "no- code" way to have a backend of 3 different tables and be able to find a value in table #3 (contains businesses & cities) by first finding a record in table #1 (7,000+ zip codes) that corresponds to a city (table #2 has the unique cities), and then finding which businesses are located in these cities ( in this specific, original zipcode lookup). And return the business and a description via an API to a front-end results page, which happens to be a WordPress page - but doesn't need to be. I've tried Airtable's API, AirPress (a finicky WordPress plugin for Airtable's API), and I've looked at Sheetsu and a similar spreadsheet as backend and a simple API. I run into the issue where they work fine when you just need to query 1 table, but when you need to use the result from that query in another query to a different table. I'm back in SQL land - where sure it could be done with SQLite - needing to probably create an intersection table or a JOIN and build an API off of that. Is there a way to accomplish what I want without going back to SQL queries and some API?

59.9k views59.9k

Comments

Detailed Comparison

Sheetsu	Portia
Use spreadsheet as your database. Give data to your users the nice way, directly from the tool you know. Without bothering webdeveloper.	Portia is an open source tool that lets you get data from websites. It facilitates and automates the process of data extraction. This visual web scraper works straight from your browser, so you don't need to download or install anything.
-	Extracts data from websites based on visual selections by the user; Creates generic web scrapers which are capable of extracting data from any web page with a similar structure; Exports scraped data in CSV, JSON, JSON-lines and XML; There is a hosted version available as a free service on Scrapy Cloud which lets Portia leverage from all the features of a cloud-based production platform including scaling and scheduling jobs, data storage, QA features, and add ons
Statistics
GitHub Stars -	GitHub Stars 9.5K
GitHub Forks -	GitHub Forks 1.4K
Stacks 17	Stacks 26
Followers 91	Followers 66
Votes 8	Votes 0
Pros & Cons
Pros 8 Easy setup	No community feedback yet
Integrations
Ruby Python Google Sheets JavaScript HTML5	No integrations available

What are some alternatives to Sheetsu, Portia?

Airtable

Working with Airtable is as fast and easy as editing a spreadsheet. But only Airtable is backed by the power of a full database, giving you rich features far beyond what a spreadsheet can offer.

import.io

import.io is a free web-based platform that puts the power of the machine readable web in your hands. Using our tools you can create an API or crawl an entire website in a fraction of the time of traditional methods, no coding required.

ParseHub

Web Scraping and Data Extraction ParseHub is a free and powerful web scraping tool. With our advanced web scraper, extracting data is as easy as clicking on the data you need. ParseHub lets you turn any website into a spreadsheet or API w

ScrapingAnt

Extract data from websites and turn them to API. We will handle all the rotating proxies and Chrome rendering for you. Many specialists have to handle Javascript rendering, headless browser update and maintenance, proxies diversity and rotation. It is a simple API that does all the above for you.

Octoparse

It is a free client-side Windows web scraping software that turns unstructured or semi-structured data from websites into structured data sets, no coding necessary. Extracted data can be exported as API, CSV, Excel or exported into a database.

Kimono

You don't need to write any code or install any software to extract data with Kimono. The easiest way to use Kimono is to add our bookmarklet to your browser's bookmark bar. Then go to the website you want to get data from and click the bookmarklet. Select the data you want and Kimono does the rest. We take care of hosting the APIs that you build with Kimono and running them on the schedule you specify. Use the API output in JSON or as CSV files that you can easily paste into a spreadsheet.

Sheety

Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime.

BeautifulSoup

It works with your favorite parser to provide idiomatic ways of navigating, searching, and modifying the parse tree. It commonly saves programmers hours or days of work.

Apify

Apify is a platform that enables developers to create, customize and run cloud-based programs called actors that can, among other things, be used to extract data from any website using a few lines of JavaScript.

2Captcha

2Captcha provides a pay-as-you-go CAPTCHA solving API for developers and automation teams. The service supports multiple CAPTCHA types including image CAPTCHAs, reCAPTCHA (v2, v3), hCaptcha, GeeTest, FunCaptcha, and Cloudflare Turnstile. The API can be integrated into Python, PHP, Java, JavaScript and other environments to automate CAPTCHA handling in scraping, testing, and browser automation pipelines.

Related Comparisons

Portia vs Sheetsu