Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

Data Sync & ETL

Classify Sustainability Procedures with OpenAI and Log Them to Google Sheets

Runs on manual trigger; uses OpenAI to tag procedures, keeps only sustainability-related items via an IF filter, and writes reference, committee, rapporteur and title to a Google Sheet.

Import it free Sign in to open it

What it does

### 3. Topics related to sustainability are stored in a Google Sheet The output of the LLM is combined with the other fields. A IF node filters out all the procedure not related to sustainability. The remaining items are loaded in a Google Sheet. #### How to setup? - Record outputs in the Google Sheet Node: 1. Add your Google Sheet API credentials to access the Google Sheet file 2. Select the file using the list, an URL or an ID 3. Select the sheet in which you want to record your working sessions 4. Map the fields: Reference Number. Committee, Rapporteur, Title/Description, PDF Link [Learn more about the Google Sheet Node]({{ $env.WEBHOOK_URL }}

The steps

  1. Loop Over Items
  2. Merge
  3. If Node
  4. Extract Yesterday Records
  5. Extract HTML Blocks
  6. Parse Blocks
  7. Google Tasks
  8. When clicking ‘Test workflow’
  9. Classification Agent
  10. Collect Answer
  11. Record Sustainability Procedures
  12. Edit Links

Similar automations

AI Agents & AssistantsAssess Company Sustainability and Animal Welfare with AI10 stepsEmail AutomationCurate Sustainability News Emails with OpenAI and Gmail29 stepsEmail AutomationSend an AI Sustainability Newsletter with GPT-4o and Gmail16 stepsDocuments, PDF & OCRAudit Sustainability Reports by Email with GPT-410 steps