İç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 / Finans, Faturalar ve Muhasebe

Finans, Faturalar ve Muhasebe

Sohbet Mesajlarından Gider ve Faturaları OpenAI ile Kaydet

Bir webhook sohbet mesajı veya görsel aldığında bir OpenAI ajanı bunun gider mi fatura mı olduğunu kontrol eder, Google Sheets'e kaydeder ve yanıt verir.

Ne yapar

## Prompt en Check relevance: If the text is not an expense record or invoice, immediately stop all processing. If it is bookkeeping-related, extract the six data fields below. Extract these six pieces of information: 1. Date (All numbers. If the input only says “today”, use {{ $now.format('YYYY-MM-DD') }}) 2. Channel (Free text from the input) 3. Channel Type (Must be exactly one of: Convenience Store, Personal Care Store, Hypermarket / Supermarket, Traditional Market, Online Shopping, Pharmacy, Hardware Store, Restaurant / Food, Stall, Medical Clinic / Hospital, 3C / Electronics Mall, Airline / Passenger Transport, Software Top-Up, Gas / Transit Top-Up, Online Course, Telecom Company) 4. Expense Description (Free text from the input) 5. Amount 6. Category (Must be exactly one of: Household, Main Meals, Drinks & Desserts, Household Items, Beauty, Clothing & Accessories, Transport, Entertainment, Telecom, Medical, 3C, Software, Learning, Travel) Output format: JSON :{\"Date\": \"...\", \"Channel\": \"...\", \"Channel Type\": \"...\", \"Expense Description\": \"...\", \"Amount\": \"...\", \"Category\": \"...\"}" ## Prompt zh 分析出資訊: 先判斷是否為記帳相關明細、發票,若不是則不需要處理,直接停止所有流程。若是記帳相關,分析出六個資訊: 1. 日期(如果只提到'今天',用{{ $now.format('YYYY-MM-DD') }} ) 2. 通路 3. 通路類型(只能為:便利商店、個人用品店、量販超市、傳統市場、網路購物、藥局、五金百貨、餐廳小吃店、醫療院所、3C商場、航空客運、軟體儲值、加油交通儲值、線上課程、電信公司)4. 花費明細 5. 金額 6. 類別(只能為:家用、正餐飲食、飲料甜點、生活用品、美妝、衣服飾品、交通、娛樂、電信、醫療、3C、軟體、學習、旅遊)。若通路類型判斷為航空客運,類別一定為旅遊。若無法判斷或沒資訊,請填入'DN',每格都要有資料。請輸出為 JSON 格式,例如:{\"日期\": \"...\", \"通路\": \"...\", \"通路類型\": \"...\", \"花費明細\": \"...\", \"金額\": \"...\", \"類別\": \"...\"}"

Adımlar

  1. Webhook
  2. message
  3. image
  4. AI Agent
  5. OpenAI Chat Model
  6. reply_to_line
  7. Get row(s) in sheet
  8. Merge_all
  9. reply_to_line_duplicated
  10. reply_to_line_no_spending
  11. Structured Output Parser
  12. append_to_sheet1
  13. Aggregate
  14. deduplication

Toplam 17 adım.

Benzer otomasyonlar