Hi there @abel.aniley…
The 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?