move-data

A Python package for moving data between Google Sheets, SharePoint, Google Cloud Storage, and Snowflake.

Features

Google Sheets Integration: Extract data from Google Sheets with automatic column name normalization
SharePoint Integration: Download and upload files from SharePoint Online
Google Cloud Storage: Retrieve files from GCS buckets
Snowflake Integration: Load data to and extract data from Snowflake databases

Installation

pip install move-data

Usage

Google Sheets

from move_data import get_googlesheets_data

data, sf_query, sf_tr_query = get_googlesheets_data(
    name="My Spreadsheet",
    sheet="Sheet1",
    service_account_path="/path/to/service_account.json",
    skip_rows=0  # Optional: skip first N rows
)

SharePoint

from move_data import sharepoint

sp = sharepoint(
    client_id="your_client_id",
    client_secret="your_client_secret",
    tenant_id="your_tenant_id",
    site_id="your_site_id",
    library_name="Documents",
    drive_id="your_drive_id"
)

data, sf_query, sf_tr_query, file, api_url = sp.get_data(
    search_query="filename",
    relative_path="folder/path",
    date_col="date_column",
    sheet_name="Sheet1",
    skip_rows=0
)

Snowflake

from move_data import snowflake

sf = snowflake(
    user="username",
    pw="password",
    database="database_name",
    schema="schema_name",
    role="role_name"
)

# Load data to Snowflake
sf.load_data(sf_query, sf_tr_query, "table_name", data, change_tracking=True)

# Get data from Snowflake
df = sf.get_data(sheet_name="Sheet1", search_query="SELECT * FROM table")

Google Cloud Storage

from move_data import googlestorage

gs = googlestorage(service_account="/path/to/service_account.json")

df = gs.get_data(
    bucket_name="my-bucket",
    path="folder/path",
    search_query="filename",
    sheet_name="Sheet1",
    skip_rows=0
)

Requirements

Python 3.7+
See pyproject.toml for full dependency list

License

MIT

Contributing

Contributions are welcome! Please open an issue or submit a pull request.

Release files for move-data 0.2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for move-data 0.2.0
File	Size	Uploaded
move_data-0.2.0.tar.gz	7.1 kB	Aug 6, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for move-data 0.2.0
File	Interpreter	ABI	Platform	Reset
move_data-0.2.0-py3-none-any.whl 7.8 kB Aug 6, 2026	Python 3	none	any	Details

Total release size: 14.9 kB

Release files / move_data-0.2.0.tar.gz

Download URL	move_data-0.2.0.tar.gz
Size	7.1 kB
Tags	Source
SHA-256 checksum How to use checksums	`abce33d6f82a5c831ef1be502812b5ff1491d0524d11a50f3eb4642cd1f2ad55`
BLAKE2b-256 checksum How to use checksums	`537a26b9b3d488af066283683e8bb5c4a99b40e4587fa6724403c7fc2adafa49`
Upload date	Aug 6, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/6.2.0 CPython/3.9.6`

Release files / move_data-0.2.0-py3-none-any.whl

Download URL	move_data-0.2.0-py3-none-any.whl
Size	7.8 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`f8739fd2485212c1ec154184793a5b7a0ec05877c3751bea08e51f8367a1e331`
BLAKE2b-256 checksum How to use checksums	`111494d72ef267e90d2a41433b743e2a92600d35e8fc61094ec084b968831233`
Upload date	Aug 6, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/6.2.0 CPython/3.9.6`