Back to Integrations
Google Sheets
Papyrs
integrationGoogle Sheets node
integrationPapyrs node
HTTP Request

Google Sheets and Papyrs integration

Save yourself the work of writing custom integrations for Google Sheets and Papyrs and use n8n instead. Build adaptable and scalable Data & Storage, and Productivity 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 Papyrs

  • 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 Papyrs integration: Create a new workflow and add the first step

Step 2: Add and configure Google Sheets and Papyrs 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 Papyrs app to the workflow select the HTTP Request node and use the generic authentication method to make custom API calls to Papyrs. Configure Papyrs and Google Sheets one by one: input data on the left, parameters in the middle, and output data on the right.

Google Sheets and Papyrs integration: Add and configure Google Sheets and Papyrs nodes

Step 3: Connect Google Sheets and Papyrs

A connection establishes a link between Google Sheets and Papyrs (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 Papyrs integration: Connect Google Sheets and Papyrs

Step 4: Customize and extend your Google Sheets and Papyrs 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 Papyrs with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Google Sheets and Papyrs integration: Customize and extend your Google Sheets and Papyrs integration

Step 5: Test and activate your Google Sheets and Papyrs workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Google Sheets to Papyrs 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 Papyrs integration: Test and activate your Google Sheets and Papyrs workflow

Build your own Google Sheets and Papyrs integration

Create custom Google Sheets and Papyrs 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 Papyrs

To set up Papyrs 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 Papyrs to query the data you need using the API endpoint URLs you provide.

  • Pages
  • Page
  • Feed
  • Records
  • Widgets
  • Attachment
  • Paragraph
  • Heading
  • Search
  • People
List pages
Retrieve all pages for a user.
GET
/api/v1/pages/all/?auth_token=123456789012
Get page
Returns a dictionary with page information.
GET
/api/v1/pages/get/(#page_id)
Get all pages
Get a list of all pages visible to the user making the request.
GET
/api/v1/pages/all/
Delete page
Deletes a page based on the provided page ID.
POST
/api/v1/pages/delete/(#page_id)/
Create page
Creates a new page with the provided content and settings.
POST
/api/v1/pages/create/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Create paragraph
Create a new paragraph in the specified page.
POST
/api/v1/page/SKTL/paragraph/create/?auth_token=123456789012&format=html

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Post feed
Submit a new post to the feed.
POST
/api/v1/feed/post/?auth_token=111222333444
Post to the Activity Stream
Post a comment to the Activity Stream.
POST
/api/v1/feed/post/
Post to discussion stream
Post a comment to a discussion stream on a specific page.
POST
/api/v1/feed/post/(#page_id)/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
List records
Returns a list of all form records submitted on the specified page.
GET
/api/v1/pages/records/(#page_id)/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Get widget
Retrieves details of a specific widget by its ID on the specified page.
GET
/api/v1/page/(#page_id)/paragraph/get/(#widget_id)/
Get widget
Retrieves details of a specific heading widget by its ID on the specified page.
GET
/api/v1/page/(#page_id)/heading/get/(#widget_id)/
Get widget
Retrieves details of a specific attachment widget by its ID on the specified page.
GET
/api/v1/page/(#page_id)/attachment/get/(#widget_id)/
Create paragraph widget
Creates a new text box widget on the specified page.
POST
/api/v1/page/(#page_id)/paragraph/create/
Create heading widget
Creates a new heading widget on the specified page.
POST
/api/v1/page/(#page_id)/heading/create/
Update paragraph widget
Updates an existing text box widget on the specified page.
POST
/api/v1/page/(#page_id)/paragraph/update/(#widget_id)/
Update heading widget
Updates an existing heading widget on the specified page.
POST
/api/v1/page/(#page_id)/heading/update/(#widget_id)/
Create attachment widget
Creates a new attachment widget on the specified page.
POST
/api/v1/page/(#page_id)/attachment/create/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Create attachment
Create a new attachment widget on a page.
POST
/api/v1/page/SKTL/attachment/create/
Update attachment
Update an existing attachment widget on a page.
POST
/api/v1/page/(#page_id)/attachment/update/(#widget_id)/
Delete attachment
Delete an attachment widget from a page.
POST
/api/v1/page/(#page_id)/attachment/delete/(#widget_id)/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Delete paragraph
Delete a paragraph widget from a page.
POST
/api/v1/page/(#page_id)/paragraph/delete/(#widget_id)/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Delete heading
Delete a heading widget from a page.
POST
/api/v1/page/(#page_id)/heading/delete/(#widget_id)/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Search
Get a list of search results based on a query.
GET
/api/v1/search/query/

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 Papyrs official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow
Or explore 800+ other templates here
Get all people
Get a list of all people in your account.
GET
/api/v1/people/all/
Delete user
Permanently delete a user from your account.
POST
/api/v1/people/delete/(#user_id)/

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 Papyrs 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 Papyrs 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.

integrationPapyrs node
HTTP Request
Papyrs

Papyrs is a cloud-based collaboration platform that allows users to create, manage, and share content within teams and organizations. It offers features like document collaboration, knowledge sharing, task management, and integrates with other tools to streamline workflows.

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

Google Sheets and Papyrs 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 Papyrs?

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

  • Can I use Papyrs’s API with n8n?

  • Is n8n secure for integrating Google Sheets and Papyrs?

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

Need help setting up your Google Sheets and Papyrs integration?

Discover our latest community's recommendations and join the discussions about Google Sheets and Papyrs 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 Papyrs in your company?

Contact Sales

Over 3000 companies switch to n8n every single week

Why use n8n to integrate Google Sheets with Papyrs

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.