sheetwork

v1.0.7

A handy CLI tool to ingest GoogleSheets into your database without writing a single line of code For more information about how to use this package see README

Latest version published 4 years ago

License: MIT

PyPI

GitHub

Package Health Score

39 / 100

security
Security review needed
popularity
Limited
maintenance
Inactive
community
Limited

Popularity

Limited

GitHub Stars: 16
Forks: 3
Contributors: 6

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package sheetwork, we found that it has been starred 16 times.

Security

Security review needed

Security and license risk for latest version

Release Date: Jan 27, 2021
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
7
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

MIT

Security Policy

We found a way for you to contribute to the project! Looks like sheetwork is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Inactive

Commit Frequency

No Recent Commits

Open Issues: 24
Open PR: 14
Last Release: 4 years ago
Last Commit: 2 years ago

Further analysis of the maintenance status of sheetwork based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Inactive.

An important project maintenance signal to consider for sheetwork is that it hasn't seen any new versions released to PyPI in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Limited

Readme: Yes
Contributing.md: Yes
Code of Conduct: No
Contributors: 6
Funding: Yes

This project has seen only 10 or less contributors.

We found a way for you to contribute to the project! Looks like sheetwork is missing a Code of Conduct.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.6.1,<4.0

Age: 5 years
Latest Release: 4 years ago
Dependencies: 14 Direct / 48 Total
Versions: 27
Maintainers: 1
Wheels: OS Independent

Readme

Sheetwork Build

sheetwork 💩🤦

What is sheetwork?

sheetwork is a handy open-source CLI-tool that allows non-coders to ingest Google Spreadsheets directly into their databases with control over data types, renaming, basic data sanitisation etc.

It offers a "close to no code" workflow that can still live alongside your codebase as all configuration lives in text files and is easily version-controllable. This makes it an ideal tool for teams.

⚠️ warning sheetwork is still in its early inception (don't get fooled by the 1 in the version). Please do some testing before you end up using it in production, and feel free to report bugs.

compatibility:

Python: 3.6, 3.7, 3.8 OS: Mac OSX >10.14, Linux

So far all our unit tests work on Windows (tested in GitHub Actions) but no comprehensive testing has been done on this platform.

sheetwork currently only offers support for cloud database Snowflake. However, its design follows an adapter pattern (currently in the making) and can be extended to interact with most databases. Feel free to check how you can contribute to the project or reach out on Discord..

Why use sheetwork?

Getting google sheets into any database often requires writing custom Python code that interacts with the Google API. That's fine if you can write Python, but it may not always be an option. On top of that, if your workflow requires you to ingest a bunch of sheets you may find yourself writing the same boiler plate code over and over.

Sheetwork offers a way to bring some DRY practices, standardisation, and simplification to basic google sheet ingestion. It won't do a lot of transformations and doesn't have room for baking in much transformational logic because we believe this is best done by fully-fledged ETL open-source tools such as dbt.

🙋🏻‍♂️ Want to use sheetwork on other databases? Let's talk! (Make an issue, or ping me on Discord)

Installation & Documentation

Head over to the pretty documentation.

sheetwork dependencies

cerberus colorama gspread inflection luddite oauth2client packaging pandas pretty-errors pyyaml requests retrying snowflake-sqlalchemy sqlalchemy

FAQs

What is sheetwork?

A handy CLI tool to ingest GoogleSheets into your database without writing a single line of code. Visit Snyk Advisor to see a full health score report for sheetwork, including popularity, security, maintenance & community analysis.

Is sheetwork popular?

The python package sheetwork receives a total of 150 weekly downloads. As such, sheetwork popularity was classified as limited. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is sheetwork well maintained?

We found indications that sheetwork is an Inactive project. See the full package health analysis to learn more about the package maintenance status.

Is sheetwork safe to use?

While scanning the latest version of sheetwork, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 17 November-2024, at 14:51 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

Package Health Score

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Readme

sheetwork 💩🤦

What is sheetwork?

Why use sheetwork?

Installation & Documentation

sheetwork dependencies

FAQs

What is sheetwork?

Is sheetwork popular?

Is sheetwork well maintained?

Is sheetwork safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues