Idea: Manually Trigger Netlify Build

(h/t GPT-4-mini via Copilot)

Manually trigger Netlify Build. During the build process, fetch the data from Airtable and save it as a static JSON file in the public directory. Update frontend to fetch data from the static JSON file.

Trigger build from a web interface or a Google Sheet button. I like the second approach. Can use the same sheet that's used for changing display months.

Create a Web Interface

Build a simple web page with a button that triggers the Netlify build hook when clicked.
The button would send a POST request to the Netlify Build Hook URL.
Example:

<!-- filepath: /public/trigger-build.html -->

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Trigger Netlify Build</title>
</head>
<body>
    <button id="trigger-build">Trigger Build</button>
    <p id="status"></p>
    <script>
        document.getElementById('trigger-build').addEventListener('click', async () => {
            const status = document.getElementById('status');
            status.textContent = 'Triggering build...';
            try {
                const response = await fetch('https://api.netlify.com/build_hooks/YOUR_BUILD_HOOK_ID', {
                    method: 'POST',
                });
                if (response.ok) {
                    status.textContent = 'Build triggered successfully!';
                } else {
                    status.textContent = 'Failed to trigger build.';
                }
            } catch (error) {
                status.textContent = 'Error: ' + error.message;
            }
        });
    </script>
</body>
</html>

Use a Google Sheet Button

Add a button in a Google Sheet that triggers the Netlify Build Hook.

Steps to implement:

Open the Google Sheet and go to Extensions > Apps Script.
Add the following script:

function triggerNetlifyBuild() {
    const url = 'https://api.netlify.com/build_hooks/YOUR_BUILD_HOOK_ID';
    const options = {
        method: 'post',
        muteHttpExceptions: true,
    };
    const response = UrlFetchApp.fetch(url, options);
    Logger.log(response.getContentText());
}

Save the script and give it a name.
Go back to the Google Sheet, and under Extensions > Macros > Import Macro, select the triggerNetlifyBuild function.
Add a button to the sheet:

Go to Insert > Drawing, create a button, and place it on the sheet.
Click the three dots on the button, select Assign script, and enter triggerNetlifyBuild.

Now, any non-technical person (without needing access to netlify) can click the button in the Google Sheet to trigger the Netlify build.

Cache Airtable API response #19

Description

Problem

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions