GPT3 AI Content from Airtable to Webflow

YouTube Video

Steps

1. Create accounts
• Airtable
• OpenAI
• Zapier
• Webflow

2. For Semi-automated
Script code (original)
https://community.airtable.com/t5/show-tell/summarizing-text-with-openai-api/td-p/124838
Script code (modified) for multiple lines

let str = data.choices[0].text;

3. For Fully automated
• Upgrade to Pro Plan of Airtable
Script code for “Run as script”

// Change this to the name of a table in your base
let table = base.getTable('Resume Keywords');
let view = table.getView('Generate Content');

let openaiUrl = "https://api.openai.com/v1/engines/text-davinci-003/completions";

let inputConfig = input.config();

let pageName = table.getField("Page Name");
console.log(pageName,"Page Name")


let results = await view.selectRecordsAsync({fields: table.fields});
console.log(results,"Results")

for (let record of results.records) {

    let pageName = record.getCellValue("Page Name");
    console.log(pageName,"Page Name 1")

    // Construct the body
    // Change the field name to match yours.
    let keywords = {
        "prompt": "List down 10 " + pageName + "\n\nskill keywords separated by commas",
        // "prompt": "List down 10 " + record.("Page Name") + "\n\nskill keywords separated by commas",
        "temperature": 0.7,
        "max_tokens": 512,
        "top_p": 1.0,
        "frequency_penalty": 0.0,
        "presence_penalty": 0.0
        }
    
        console.log(pageName,"Page Name")


    // Make a request to OpenAI API
    // Add your own API key in the place of Xses.
    let response = await fetch(openaiUrl, {
        method: 'POST',
        body: JSON.stringify(keywords),
        headers: {
            'Content-Type': 'application/json',
            'Authorization': 'Bearer xx',
        },
    });
    let keyData = await response.json();

    // Comment this out if you don't want to see any outputs
    console.log(keyData)

    let str = /[^A-Za-z0-9](.+)/.exec(keyData.choices[0].text)[1];

		// for multi-line output use the below
    //let str = keyData.choices[0].text;

    // Write to a cell, change field name to match your table.

await table.updateRecordAsync(record,{
        'Resume Keywords': str,});
}