Advanced Configurations
Table of Contents
🔁 Enable Auto-Run
You can create a time-driven trigger for your Apps Script with the following steps:
- Open an Apps Script Editor from your Google Sheet file.
- On the left, click on Triggers ⏰.
- At the bottom right, select Add Trigger.
-
In the dialog, choose the function to run and configure an appropriate time interval (e.g., every 6-12 hours) to run periodically, as the example below.
You can set up the script to run automatically at regular intervals using a time-driven trigger. This way, you don’t have to manually run the script every time you want to download the Stories. To do this, you need to:
- Open your Google Sheet file and go to the Extensions menu. Select Apps Script to open the script editor.
- On the left panel of the script editor, select ⏰ Triggers.
- Click on the ➕ Add trigger button at the bottom right corner of the screen.
- In the Choose which function to run dropdown, select run,which is the main function of the script that downloads the Stories.
- In the Select event source dropdown, select Time-driven. This means the script will run based on a time schedule.
- In the Select type of time based trigger dropdown, select Hour timer. This means the script will run every few hours.
- In the Select hour interval dropdown, select how often you want the script to run. You can choose from every hour to every 24 hours (every 12 hours is recommended, this means the script will run twice a day).
- Click on the Save button.
Note: You may be asked to authorize the script to access your Google account. Follow the instructions on the screen to grant the necessary permissions.
⚠️ Warning
Please be careful not to overuse the script! You may be logged out and asked to confirm your identity when you try to log in again.
💡 Tip: To avoid this, you should log in to the Instagram website every 2-3 days using Chrome on your PC. This will keep your cookies and session valid for longer.
🛑 Caution
If you download too many Stories in a short period of time, Instagram may detect unusual activity from your account and temporarily restrict certain actions.
That’s it! You have successfully set up a time-driven trigger to run the script automatically at regular intervals. 🎉
You can check the Logs sheet in your Google Sheet file to see the file download activities and the status of the script. If you encounter any errors or issues, please refer to the Troubleshooting section of the documentation.
🩺 Set Up Health Check
Instagram may change its API endpoint and data structure without any announcements. Therefore, you may want to set up a health monitoring to check if the script can access and process the Instagram data correctly.
test_pipeline()
is a function that performs a health check, updates the badges, and sends error report emails. The health check passes if it detects stories from the following Instagram accounts:
Account | Description |
---|---|
bbcnews | BBC News |
cnn | CNN |
medium | Medium |
nasa | NASA |
These accounts are chosen because they publish stories frequently. If the health check fails, it means there is an error in accessing the API endpoint or interpreting the media URLs from the data.
You can set up a periodic health check with the following steps:
- Open the Apps Script Editor from your Google Sheet file.
-
Add the following code to a
.gs
file:function runTestPipeline() { const IGSF = IGStoriesToGDrive.getInstance(); IGSF.test_pipeline(); }
- On the left panel, click Triggers ⏰.
- At the bottom right, click Add Trigger.
- In the dialog, choose
runTestPipeline
as the function to run and configure an appropriate timer. -
(Optional) In your Google Sheet file, enter an email address for error reporting on the “Settings” sheet.
Email To
The email address to receive an error message when the execution oftest_pipeline()
returns a “failed” status.
You can also create and display health check badges to show the last execution date and status of the test_pipeline()
function.
Here is how you do it:
- Open the page “Settings” in your Google Sheet file.
- Click the ➕ Create badges button to execute
createBadges()
. -
Open your Google Drive, you should see the two badge files,
last-tested-date.svg
andlast-tested-status.svg
, are created in the destination folder. -
Go back to the spreadsheet, their file IDs should be found on the page Settings.
- Share the SVG files to view publicly and copy their Download URLs if you want to display them on a website or monitoring page.
🛑 Deploy As a Web API (deprecated)
Important
The current version only supports web app deployment if you inject our source code directly into your script.
You can also customize the code and deploy the script as a web API. This way, you can trigger the script with HTTP GET requests from other apps.
To protect your web API endpoint, you have to set the username and password. Copy the following code to your project and replace myUsername
and myPassword
with your values:
function setUserProperties() {
PropertiesService
.getUserProperties()
.setProperty('AUTH_USERNAME', 'myUsername')
.setProperty('AUTH_PASSWORD', 'myPassword');
}
Run setUserProperties()
once to store your username and password as secret properties. After that, this code is no longer necessary and you can remove it.
Now you can test your web app deployment by passing a URL with query strings like this,
https://script.google.com/<YOUR_APP_PATH>/exec?usr=<AUTH_USERNAME>&pwd=<AUTH_PASSWORD>&target={"name":"bbcnews","id":"16278726"}
You can check the “Logs” sheet to see the file download activities and the status of the script.
If you need any help or have any feedback, you can visit the project GitHub repository or contact me through this website. I hope you enjoy using this tool and saving your favorite Instagram Stories to your Google Drive. 😊