n8n Workflow: Track US Fintech & Healthtech Funding Rounds

This n8n workflow is designed to periodically fetch data related to funding rounds in the US Fintech and Healthtech sectors and store it in a Google Sheet. It automates the process of querying an API (likely Crunchbase, based on the directory name) and maintaining a record of the retrieved information.

What it does

This workflow performs the following key steps:

1. Triggers on a Schedule: The workflow is initiated at predefined intervals by a Schedule Trigger node.
2. Fetches Data from an API: It makes an HTTP Request to an external API to retrieve information. Based on the directory name, this is likely an API for Crunchbase or a similar funding data provider.
3. Processes Data with Custom Code: A Code node is used to execute custom JavaScript logic. This step likely transforms, filters, or extracts specific data points from the API response before it's written to the spreadsheet.
4. Writes to Google Sheets: The processed data is then appended or updated in a specified Google Sheets spreadsheet.
5. Provides Context with a Sticky Note: A Sticky Note is included, usually for documentation or to highlight important information within the workflow itself.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential configured for Google Sheets to allow the workflow to write data.
• API Access: Access to the external API from which funding data will be pulled (e.g., Crunchbase API key, if applicable). The HTTP Request node will need to be configured with the appropriate URL, headers, and authentication.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential in n8n if you haven't already. Connect the Google Sheets node to this credential.
3. Configure HTTP Request:
   • Update the HTTP Request node with the correct API endpoint, request method, headers (including any API keys or authentication tokens), and parameters required to fetch the desired funding data.
4. Configure Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where you want the data to be written.
   • Ensure the column headers in your Google Sheet match the data being output by the Code node.
5. Configure Schedule Trigger:
   • Adjust the Schedule Trigger node to your desired frequency for running the workflow (e.g., daily, weekly).
6. Review the Code Node:
   • Examine the JavaScript code within the Code node to understand how the API response is being processed and transformed. Modify it if necessary to extract different data points or apply custom logic.
7. Activate the Workflow: Once configured, activate the workflow to start tracking funding rounds automatically.