Track your book reading progress, send to Google Sheets.

Hey Reddit!

I’m not a good book reader. I also want to become one, so I made a shortcut to log my reading progress.

You log the page you’re currently reading and it will send that data to Google Sheets.

Link to the shortcut: https://www.icloud.com/shortcuts/75a2a4266a5e43d8bf24c3aa0f400fc6

Dependencies:
• IFTTT
• Google Sheets

All you need is to have a premade spreadsheet on Google Sheet and an IFTTT applet.

IFTTT

1. Go to IFTTT and create an applet

2. IF THAT: Webhook. Event name: "book_log".

3. THEN THAT: Google Sheets. Spreadsheet name: "book_log". Formatted row: {{Value1}} |||{{Value2}}

4. Go to https://ifttt.com/services/maker_webhooks/settings, copy and execute an URL as on the screenshot.

5. Then copy a link that is similar to https://maker.ifttt.com/trigger/book_log/with/key/Y0URL0NGK3YG03SH3R3. Make sure you type "book_log" into the {event} field.

6. Paste that link into the Shortcut.

Google Sheets

1. Go to https://docs.google.com/spreadsheets/d/1vYSO3B3YzdOaEriqwr3GbulJX9ZiJ_JGNP3GBj9fD_8/edit?usp=sharing and save the sheet as Microsoft Excel file.

2. Then go to https://drive.google.com/drive/u/0/my-drive and drag-and-drop Excel file.

3. Open the file with Google Sheets.

4. Sheet "!" is for the shortcut to import data.

5. Sheet "Data" is to analyze how many pages did you read, how is your progress, etc.

That's it!

Is there any suggestions I can make that shortcut better?

Thank you!