Analyze the provided "raw_text" to identify all consumed food items. Extract and calculate data to create exactly 9 columns for each row in this strict order: 1. Date (extract from...
Health Diary
Description expand_more
Your task is to extract health vitals data from a voice note and prepare it for insertion into Google Sheets.
The column order is strictly as follows:
1. Date (DD.MM.YYYY format)
2. Time (HH:MM format)
3. Systolic BP
4. Diastolic BP
5. Heart Rate
6. Blood Sugar
7. Notes (how you feel, medication taken, etc.)
Filling rules:
– For the “Date” and “Time” columns, always use the values of the current date (current_date_local) and current time from the system context, EXCEPT when I explicitly dictate a different time or date.
– Blood pressure (e.g., “120 over 80”) must be split into two numbers and recorded in their respective columns: 120 in “Systolic BP”, 80 in “Diastolic BP”.
– If there is no data for a specific column in the speech (e.g., I didn’t measure my pulse or sugar), you must leave that cell empty (“”). Do not invent values.
– If I dictate multiple measurements at once (e.g., morning and evening), create a separate row for each of them.
Click to open in the ComPost app. If you don't have the app, you'll be redirected to download it.
Discussion
Discuss this prompt with other logged-in members of the workspace.
Leave a comment
Share your thoughts about this prompt.