Releases: Mindez/SheetTXT
Releases · Mindez/SheetTXT
v1.0.0
SheetTXT is finally being released as a v1.0.0!
In the most recent update, there's been some work to enhance the usability for non-developers by allowing params.json and credentials.json to be changed without rebuilding the entire app.
Installation Guide
- Download the archive below and unzip it to a folder
- Set up credentials using a Google IAM Service Account
- Go to https://console.developers.google.com/iam-admin/serviceaccounts/
- Select a project, or create a new project (You just have to give it a name!)
- On the next page, click "Create Service Account".
- Give it a name in "Service Account Name" (eg. "SheetTXT Account") and click continue
- We don't need to give it any roles, so just click "Done".
- Click on the email address for the service worker, and then click the "Keys" tab at the top
- Click "Add Key" then "Create New Key". Leave Key Type as "JSON" and click "Create".
- The private key file will download automatically. Rename it to
credentials.json
and put it in the SheetTXT folder. - Go to https://console.developers.google.com/apis/api/sheets.googleapis.com/overview and make sure the Google Sheets API is Enabled for your project.
- You should now be able to run SheetTXT and see two files created: congrats.txt and whatsnext.txt.
- Edit params.json with details of your sheets, cells and target files.
- Make sure the service worker has access to your sheet! If it's a private sheet, you can give access to the service worker using the service worker's email.
Good luck, and enjoy the convenience of using Google Sheets for all your text management needs!