1 unstable release
0.1.2 | May 2, 2022 |
---|
#23 in #sheet
11KB
165 lines
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.
Dependencies
~18–33MB
~578K SLoC