Skip to content
FlowHubFluxonLab
Email (SMTP)
Finance & Accountingfree

Scheduled API Sync to NocoDB and Email

by ŁukaszUpdated Aug 2026
RequiresEmail (SMTP)Email (SMTP)
Share Post Share
Se⚙️ ConfigHRGet Public KeyHRGet ChallengeCoEncrypt TokenHRInit AuthHRCheck Auth StatusCheck Auth Stat…HRRedeem TokenCoExtract InvoicesESSend an EmailCTConvert to FileCoCovert to Base64HRQuery Cost InvoicesQuery Cost Invo…HRQuery Issued InvoicesQuery Issued In…MeProcess only new invoicesProcess only ne…SIFor each invoiceHRGet invoice detailsGet invoice det…Xmto JSONCoConvert to HTMLMeCreated row with file input to be sentCreated row wit…NDInsert new invoice detailsInsert new invo…MeProcess both typesProcess both ty…NDGet existing invoicesGet existing in…SeMark as "issued" invoiceMark as "issued…SeMark as "cost" invoiceMark as "cost" …MeCombine HTML with base invoice dataCombine HTML wi…ScMonitor Every Day for new invoicesMonitor Every D…WaWaitHRTerminate Auth SessionTerminate Auth …WaWait 2sMaCreate TablesSeNocoDB ConfigHRCreate NocoDB KSeF Invoices TableCreate NocoDB K…123456789101112131415161718192021222324252627282930313233
1/5
FLOWS
STEPS · 33
Runs on a schedule

On a schedule, fetches data via HTTP, stores records in NocoDB in batches, and emails a generated file report via SMTP.

Tags

cronadvancedEmail (SMTP)Invoice Processing
Connects
emailsmtpEmail (SMTP)
CategoryFinance & Accounting
Triggercron
Complexityadvanced
Nodes32
AddedJun 14, 2026