serde_sheets

Read and write structs directly from google sheets using serde and csv

Implement serde::Serialize to write and serde::Deserialize to read. Easy!

Motivation

Google sheets API is somewhat complex and requires lots of boilerplate. Reading and writing involves using lots of Vec<Vec<String>>. We use csv crate to automate creating these payloads and converting them back into your structs

Usage

serde_sheets expects a google service account json to be available as SERVICE_ACCOUNT_JSON:

$ export SERVICE_ACCOUNT_JSON=$(cat my-service-account.json)

Build Sheets object:

let service_account = service_account_from_env().unwrap();
let mut sheets = get_sheets(service_account, Some("token_cache.json"))
    .await
    .unwrap();

Write objects:

serde_sheets::write_page(&mut sheets, "some-document-id", "some-tab-name", &objects)
    .await
    .unwrap();

Read objects:

let returned: Vec<ExampleObject> = serde_sheets::read_all(&mut sheets, DOCUMENT_ID, TAB_NAME)
    .await
    .unwrap();

Check examples/example.rs for full example.

$ cargo run --example example

License

Licensed under either of

• Apache License, Version 2.0, (LICENSE-APACHE or https://www.apache.org/licenses/LICENSE-2.0)
• MIT license (LICENSE-MIT or https://opensource.org/licenses/MIT)

at your option.

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.