Back to Integrations
Google Sheets
Nightfall.ai
integrationGoogle Sheets node
integrationNightfall.ai node
HTTP Request

Google Sheets and Nightfall.ai integration

Save yourself the work of writing custom integrations for Google Sheets and Nightfall.ai and use n8n instead. Build adaptable and scalable Data & Storage, Productivity, and AI workflows that work with your technology stack. All within a building experience you will love.

Get started
See n8n in action

How to connect Google Sheets and Nightfall.ai

  • Step 1: Create a new workflow
  • Step 2: Add and configure nodes
  • Step 3: Connect
  • Step 4: Customize and extend your integration
  • Step 5: Test and activate your workflow

Step 1: Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Google Sheets and Nightfall.ai integration: Create a new workflow and add the first step

Step 2: Add and configure Google Sheets and Nightfall.ai nodes (using the HTTP Request node)

You can find the Google Sheets node in the nodes panel and drag it onto your workflow canvas. To add the Nightfall.ai app to the workflow select the HTTP Request node and use the generic authentication method to make custom API calls to Nightfall.ai. Configure Nightfall.ai and Google Sheets one by one: input data on the left, parameters in the middle, and output data on the right.

Google Sheets and Nightfall.ai integration: Add and configure Google Sheets and Nightfall.ai nodes

Step 3: Connect Google Sheets and Nightfall.ai

A connection establishes a link between Google Sheets and Nightfall.ai (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.

Google Sheets and Nightfall.ai integration: Connect Google Sheets and Nightfall.ai

Step 4: Customize and extend your Google Sheets and Nightfall.ai integration

Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Google Sheets and Nightfall.ai with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Google Sheets and Nightfall.ai integration: Customize and extend your Google Sheets and Nightfall.ai integration

Step 5: Test and activate your Google Sheets and Nightfall.ai workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Google Sheets to Nightfall.ai or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.

Google Sheets and Nightfall.ai integration: Test and activate your Google Sheets and Nightfall.ai workflow

Build your own Google Sheets and Nightfall.ai integration

Create custom Google Sheets and Nightfall.ai workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Google Sheets supported actions

  • Document
  • Sheet Within Document
Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet

Supported API Endpoints for Nightfall.ai

To set up Nightfall.ai integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Nightfall.ai to query the data you need using the API endpoint URLs you provide.

  • Scanpayload
  • Initiateupload
  • Uploadchunk
  • Completeupload
  • Scanupload
  • Violations
  • Violation
  • Annotation
  • Finding
  • Github-repositories
  • Annotations
  • Findings
  • Repositories
Scan Plain Text
Provide a list of arbitrary string data, and scan each item with the provided detectors to uncover sensitive information.
POST
/reference/scanpayloadv3

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Initiate File Upload
Start the upload process for a file to be scanned.
POST
/reference/initiateuploadv3

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Upload File Chunk
Upload a chunk of the file being scanned.
PATCH
/reference/uploadchunkv3

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Complete File Upload
Complete the upload process for a file that was scanned.
POST
/reference/completeuploadv3

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Scan Uploaded File
Scan a file that has been uploaded.
POST
/reference/scanuploadv3

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Fetch violations
Retrieve a list of violations identified by the DLP API.
GET
/reference/get_violations
Search violations
Search for violations using specified criteria.
GET
/reference/get_violations-search
Take an action on Violations
Perform a specified action on identified violations.
POST
/reference/post_violations-actions
Fetch violations
Fetch a list of violations for a period
GET
/dlp/v1/violations
Fetch violation
Fetch details of a specific violation by ID
GET
/dlp/v1/violations/{violationid}
Search violations
Search for violations based on specified criteria
GET
/dlp/v1/violations/search
Fetch violation findings
Fetch findings associated with a specific violation
GET
/dlp/v1/violations/{violationid}/findings
Take an action on Violations
Perform specified actions on violations
POST
/dlp/v1/violations/actions
Fetch violations
Retrieve a list of violations.
GET
/dlp/v1/violations?limit=50
Fetch violation
Fetch a violation by ID.
GET
/dlp/v1/violations/{violationId}
Fetch violation findings
Fetch findings related to a specific violation.
GET
/dlp/v1/violations/{violationId}/findings
Fetch violation
Retrieve a specific violation by its ID.
GET
/dlp/v1/violations/violationId
Fetch violation findings
Retrieve findings related to a specific violation.
GET
/dlp/v1/violations/violationId/findings
Fetch violations
Get a list of violations.
GET
/v1/violations
Fetch violation
Get details for a specific violation.
GET
/v1/violations/{violationId}
Search violations
Search for violations based on parameters.
GET
/v1/violations/search
Fetch violation findings
Get findings for a specific violation.
GET
/v1/violations/{violationId}/findings
Take an action on Violations
Perform an action on violations.
POST
/v1/violations/actions

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Fetch violation
Retrieve details for a specific violation by its ID.
GET
/reference/get_violations-violationid
Fetch violation findings
Retrieve findings related to a specific violation by its ID.
GET
/reference/get_violations-violationid-findings

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Fetch annotation
Retrieve details for a specific annotation by its ID.
GET
/reference/get_annotations-annotationid

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Annotate finding
Add an annotation to a specific finding by its ID.
POST
/reference/post_findings-findingid-annotate
Remove finding annotation
Remove an annotation from a specific finding by its ID.
POST
/reference/post_findings-findingid-unannotate

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Fetch Github Repositories
Retrieve a list of GitHub repositories.
GET
/reference/get_github-repositories
Fetch Github Repositories
Retrieve a list of connected Github repositories
GET
/dlp/v1/github-repositories
Fetch Github Repositories
Get a list of Github repositories.
GET
/v1/github-repositories

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Fetch annotation
Fetch a specific annotation by its ID
GET
/dlp/v1/annotations/{annotationid}
Fetch annotation
Fetch an annotation by ID.
GET
/dlp/v1/annotations/{annotationId}
Fetch annotation
Retrieve a specific annotation by its ID.
GET
/dlp/v1/annotations/annotationId
Fetch annotation
Get details for a specific annotation.
GET
/v1/annotations/{annotationId}

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Annotate finding
Add an annotation to a specific finding
POST
/dlp/v1/findings/{findingid}/annotate
Remove finding annotation
Remove an annotation from a specific finding
POST
/dlp/v1/findings/{findingid}/unannotate
Annotate finding
Add an annotation to a specific finding.
POST
/dlp/v1/findings/{findingId}/annotate
Remove finding annotation
Remove an annotation from a specific finding.
POST
/dlp/v1/findings/{findingId}/unannotate
Annotate finding
Add an annotation to a specified finding.
POST
/dlp/v1/findings/findingId/annotate
Remove finding annotation
Remove an annotation from a specified finding.
POST
/dlp/v1/findings/findingId/unannotate
Annotate finding
Add an annotation to a specific finding.
POST
/v1/findings/{findingId}/annotate
Remove finding annotation
Remove an annotation from a specific finding.
POST
/v1/findings/{findingId}/unannotate

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Fetch Github Repositories
Retrieve a list of GitHub repositories.
GET
/dlp/v1/github/repositories

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Nightfall.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here

Google Sheets and Nightfall.ai integration details

integrationGoogle Sheets node
Google Sheets

Google Sheets is a web-based spreadsheet program offered by Google for free. It similar to Microsoft Excel, and can be accessed anywhere on any device, you only need a Google account.

integrationNightfall.ai node
HTTP Request
Nightfall.ai

Nightfall-ai is an advanced technology leveraging artificial intelligence to protect sensitive data by automatically discovering and redacting personally identifiable information (PII). It ensures privacy by applying machine learning algorithms to aid in the secure handling of information and prevent data breaches.

Other integrations with Google Sheets
Google Sheets node
Google Sheets node
Google Sheets node
Google Sheets node

Google Sheets and Nightfall.ai integration tutorials

featured image
  • Database
  • Tutorial

How to use Google Sheets as a database

Dive into the versatility of Google Sheets as a database with our in-depth comparison of Python scripting and n8n automation. Get 7 free workflows to set up your Google Sheets database in n8n!

featured image
  • Tutorial

How to import CSV into Google Sheets: 3 best methods

Explore 3 efficient methods for importing CSV files into Google Sheets, comparing n8n's automated workflow with the manual import via native Google Sheets interface and the programmatic import via Python.

featured image
  • Tutorial

How to import XML to Google Sheets: 3 step-by-step techniques

Learn three different ways to import XML to Google sheets: with Google sheet’s IMPORTXML function, with Google AppScript and automation with n8n.

featured image
  • Tutorial

How to pull data from Google Spreadsheet to HTML: Code and no code approaches

Learn how to pull data from Google Spreadsheet to HTML using Google Apps Script and n8n automation tool.

featured image
  • Database
  • ITOps
  • Tutorial

How to connect Google Sheets to MySQL: Code and no-code methods

Discover two ways to connect MySQL with Google Sheets, and learn to build no-code workflows for automating it.

featured image
  • ITOps
  • Tutorial

How to automatically import JSON into Google Sheets

Discover three ways to import JSON data into Google Sheets or a CSV file, and five no-code workflows for automatically moving data between JSON and spreadsheets.

Load More

FAQs

  • Can Google Sheets connect with Nightfall.ai?

  • Can I use Google Sheets’s API with n8n?

  • Can I use Nightfall.ai’s API with n8n?

  • Is n8n secure for integrating Google Sheets and Nightfall.ai?

  • How to get started with Google Sheets and Nightfall.ai integration in n8n.io?

Need help setting up your Google Sheets and Nightfall.ai integration?

Discover our latest community's recommendations and join the discussions about Google Sheets and Nightfall.ai integration.
Sergey Komardenkov

Google Sheets Action is not picking up a list of available Sheets despite seeing the document itself

Sergey Komardenkov
Describe the problem/error/question I am testing a workflow where the final action is addition of a row into a Google sheet. I have created a new sheet, I gave it Edit permissions by link just in case, and of course I ad…
sérgio eduardo floresta filho

The prompt is not being executed

sérgio eduardo floresta filho
Hello! My goal is to use Google Forms to collect information from my clients and then use n8n to automate the processing of this information. My workflow involves: Collecting data through Google Forms. Using n8n to re…
Julian

Sending timestamp to Google Sheets with correct timezone

Julian
I’m trying to send a timestamp to a Google Sheet. Therefore, I use the expression $now.format(“HH:mm”).toString(). In n8n, the timestamp looks correct (see screenshot). However, in Google Sheets, the string value is …
therealJMT

Filtering rows in google sheets with empty value in specific colum

therealJMT
Describe the problem/error/question edit: I guess I figured it out. The “isEmpty()” is a boolean function and has no output it just checks in the node if it’s true or not. For my workflow I got it running with a setup th…
Guilherme

Error 400 | Google | n8n inserting too many characters in OAuth Redirect URL

Guilherme
Hello everyone, I’m having a problem logging into my Google account when I’m creating a credential for Google Sheets. :warning:Error 400: redirect_uri_mismatch I noticed that n8n is inserting an extra character in t…

Looking to integrate Google Sheets and Nightfall.ai in your company?

Contact Sales

Over 3000 companies switch to n8n every single week

Why use n8n to integrate Google Sheets with Nightfall.ai

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

Get started
red iconyellow iconred iconyellow icon

Automate without limits

Made with ♥ in Berlin
Impressum | Legal | Privacy

Report a vulnerability
© 2024 n8n | All rights reserved.