Internal Flows
Let's go over how it all works together - How Sheets interfaces with Frappe & your other Apps to setup your Data Pipeline.
Data import details
import job will fetch a subsection of the spreadsheet [counter:latest_idx] and store it as a temporary csv which will be used to create Data Import documents
Saving "SpreadSheet" document will trigger generation/updation of "Scheduled Job Type" documents / call internally defined function through Server Script defined automatically by this app. Maintain links to Server Script & Scheduled Job in doc
Use Data Import as view for the results of the import - new custom field(s) ("Generated By")