Question

Updating the excel spreadsheet directly from streamsets

  • 4 May 2023
  • 1 reply
  • 30 views

I generally run the streamsets pipeline after which the couchbase gets updated and I export the JSON file, convert it and update my google spreadsheet which I will be using further for visualizations. 

My question here is, Is there any chances I can update the spreadsheet directly through Streamsets, so as to avoid the export of JSON and convert it to excel and update the sheet. 

 


1 reply

Userlevel 5
Badge +1

@Madhumitha 

Can you please try to make it in jython or groovy script.

Reply