İçeriğe geç
YENİPazar yeri ve trig8n Agent: geliştirdiğinizi satın; planlar ve değişiklikler siz görmeden önce test edilsin. Yeniliklere bak

Kütüphane / Veri Senkronizasyonu ve ETL

Veri Senkronizasyonu ve ETL

Gaffa ile web sayfası tablosu değişikliklerini Google Sheets'e senkronize et

Zamanlanmış olarak Gaffa, bir web sayfasındaki tabloyu ayrıştırır ve bir anahtar sütuna göre Google Sheets ile karşılaştırır; yeni satırları ekler, değişen satırları yerinde günceller.

Ne yapar

## Track web page table changes with Google Sheets and Gaffa Keep a Google Sheet in step with a table on any web page and see what changed. ### Who's it for Anyone watching a table they don't control: release schedules, vendor sub-processor lists, price lists, shortage lists, rankings. ### How it works - Gaffa loads the page in a real browser and its parse_table action turns the table into rows, with the headers as column names. - The workflow reads your sheet and compares both on a key column with the Compare Datasets node. - New rows are added, changed rows are updated in place and rows gone from the page get a removed date. - Every change lands in a Changes tab with the date, the key, the type and the old and new values. - If the table cannot be read, the run stops with an error instead of marking every row as removed. ### Setup 1. Install the Gaffa community node. 2. Create an API key at gaffa.dev and add it as the Gaffa API credential. 3. Connect Google Sheets and create a spreadsheet with two empty tabs, Table and Changes. 4. In the Settings node, set the page URL, the CSS selector of the table, a key column that is unique per row and the spreadsheet URL. 5. Run it once to fill the sheet, then publish the workflow. ### Requirements - A Gaffa API key - A Google Sheets credential ### Customization tips - Gaffa lowercases headers and turns anything other than letters and numbers into underscores, so Ticket Price (£) becomes ticket_price_. Use that name as the key column. - Change the time in the Every morning node. - Send the new Changes rows by email or Slack after the Write to the change log node.

Adımlar

  1. Every morning
  2. Settings
  3. Read the table
  4. Table read?
  5. Fetch the rows
  6. Only rows with a key
  7. Rows found?
  8. Stop with an error
  9. Read the sheet
  10. Only rows still listed
  11. Compare with the sheet
  12. Mark as new
  13. Add the new rows
  14. Mark as changed

Toplam 21 adım.

Benzer otomasyonlar