Hi there @abel.aniley…
formId and everything else in that
sheetData object are attributes that you want to send from the Google Sheet to OpenFn. So here,
formId operates like a “tag”—I’ve hard-coded it so that all data coming from this Google Sheet will be marked with the attributed
formId and the value
"BeneficiaryData". Similarly, you could add an attribute like
Source: 'Abel's Google Sheet' to tag all of your data with the name of the data source.
How would you like to structure the data that you’re sending to OpenFn from your Google Sheet? You could add whatever attributes you’d like inside that
sheetData object, and re-label columns as desired.
@abel.aniley checking in… did you have any luck setting up the Google Sheet connection?