HOW TO USE

 ANALYZE

1. Open the Octo extension from your Chrome browser.
2. Access “Analyze” Feature for a one-time analysis.
3. Click “Fetch Data”. 
4. Select a sheet that contains the data you want to analyze.
5. Ask questions in the “Type your message” box.
6. Create a chart by clicking “Create Chart” once the analysis is done to visualize your findings.

SCHEDULE INSIGHTS

1. Access the Schedule Insights Section: Open the "Schedule Insights" feature in the Chrome extension interface.
2. Specify the Range: Enter the range of cells to analyze in the "Range" field (e.g., Sheet1!A1:B2).
3. Add a Prompt for Analysis: Provide the analysis prompt in the "Prompt" field to specify what kind of insights you want.
4. Enter Your Email: Input your email address in the "Email" field to receive scheduled insights.
5. Set the Email Subject: Enter a subject line for the scheduled email in the "Subject" field.
6. Define the Schedule Dates:

                     Start Date: Choose the starting date for the schedule in the "Start Date" field.

                     End Date: Specify the ending date in the "End Date" field.

            7. Choose a Day of the Week: Indicate the day (e.g., Monday) for scheduling insights in the "Day of Week" field.

            8. Set the Time: Input the time (in PST) to receive the insights email in the "Send Time" field.

            9. Enable Automation: Ensure you’ve shared the Google Sheet file with the service account (octo-680@octo-429713.iam.gserviceaccount.com)       

          10. Schedule the Insights: Click the "Schedule" button to finalize and activate the schedule.

NOTIFICATIONS

1. Access the Notification Feature: Navigate to the "Create Notification" section in the extension interface.
2. Specify the Range: Enter the desired range in the "Range" field (e.g., Sheet1!A1:B10) to monitor specific cells in your Google Sheet.
3. Set the Value to Monitor: Provide the value or condition you want to monitor in the "Value to Monitor" field.
4. Enter Notification Email: Input your email address in the "Email" field to receive notifications when the specified condition is met.
5. Create the Notification: Click the "Create Notification" button to save and activate the notification.
6. Enable  Notifications: Ensure you’ve shared the Google Sheet file with the service account (octo-680@octo-429713.iam.gserviceaccount.com)  
7. Receive Alerts: Once configured, you’ll receive email alerts whenever the specified value or condition in the selected range is triggered.