See also the Workflow Training content.

This workflow reads the data from rows in a CSV file in Google Drive, injects it into Rainbird, and outputs the results to a Google sheet.

To use this workflow:

  • Download and import the attached Hello World for Workflow.rbird file into your Rainbird platform.
  • Upload the attached Data for workflow demo.csv file to Google Drive
  • Create a new Google sheet with two columns labelled “Name” and “Result”.


Controls > OnStart component

This component starts the workflow.



Google Drive > ExportFile component

This component will get a specific file from Google Drive (‘export’ refers to exporting the file from Google Drive).

  • Google account - click the Connect new account button and follow the instructions for logging into your Google account
  • File – Now your Google account is connected you will be able to select the Data for workflow demo.csv file in your Google Drive

 

CSV > GetRows

This component will extract the information in the CSV file, row by row.
Note: Make sure you use GetRows, not GetRow!

  • Use column names – True
  • Filter Rows – False
  • File ID – Click on the Menu icon and select File ID from the ExportFile component
  • Delimiter – Enter a comma ,
  • Row format – Object
  • All rows in one message – False


Rainbird > Start component

This component links the workflow to a specific Rainbird map.

  • Base URL – Community (or other environment if applicable)
  • API key – Enter your Rainbird API key
  • Knowledge Map ID – Enter the ID for the knowledge map you want to query


Rainbird > Inject component

This component will take the data from the CSV file and inject it as facts into Rainbird.

  • Base URL – Click on the menu icon and select Start: Base URLI
  • Session ID – Click on the menu icon and select Start: Session ID
  • Data – Here you have to specify the facts to be injected into Rainbird:
    • Click on the menu and select Rows.
    • Click on the Rows and in ‘Add modifier’ select JSON Path
      • Path – type Person
  •  
    • Add a comma , (make sure there are no spaces either side of it)
      • Type lives in (the name of the relationship you are creating facts for)
      • Add a comma , (make sure there are no spaces either side of it)
      • Click on the menu and select Rows.
        • Click on the Rows and in ‘Add modifier’ select JSON Path
        • Path – type Country

 

Rainbird > Query component

This component will query the Rainbird map, once for each row in the CSV file.

 

  • Base URL – Click on the menu and select Start: Base URL
  • Session ID – Click on the menu and select Start: Session ID
  • Subject – Click on the menu and select Rows
    • Click on the Rows and in ‘Add modifier’ select JSON Path
    • Path – Enter Person
  • Relationship – Enter might speak
  • Object – Leave blank

 

Google Sheets > CreateRow component

This will take the person’s name and the answer of each query and write it to a new row in the Google sheet.

  • Google account – this should already be linked
  • Spreadsheet – Click and select the results spreadsheet you created
  • Worksheet – Click and select Sheet1 (or whichever sheet you want the answers to be written to)
  • Name – Click on the menu and select Rows
    • Click on the Rows and in ‘Add modifier’ select JSON Path
    • Path – Enter Person
  • Result - Click on the menu and select Query: Results
    • Click on the Rows and in ‘Add modifier’ select JSON Path
    • Path – Enter [0].object

 

Running your workflow

Your flow is now ready to be run. Click the Start Flow button. The workflow should automatically add new rows with the person’s name and the language they speak in the results spreadsheet.