- 06 Dec 2022
- 3 Minuten zu lesen
Google Sheets + Document360
- Aktualisiert am 06 Dec 2022
- 3 Minuten zu lesen
Many organisations use spreadsheets as the go to tool for collecting and organizing data, which is among the simplest of its uses. Google Sheets is a free, web-based spreadsheet platform by Google that allows users to organize, collaborate, analyse, and edit distinct types of information. Multiple users can format and edit files in real-time, and any changes made to the spreadsheet can be tracked by a revision history.
You are a company who is very much engaged and integrated with the Google environment and app. You have chosen Document360 to be your knowledge base platform. You maintain a log sheet of all the articles in your knowledge base. Each time a new article is added on to the Knowledge base project, an entry has to be made in the respective Google sheet. Yes, you can do it manually, but it takes more effort and is quite time consuming.
Currently, there is no direct integration option available between Google Sheets and Document360 from either of the platforms.
As a workaround you can use Zapier integration to bridge this gap. By connecting Document360 and Google sheets on Zapier, you can easily facilitate the content flow between these platforms.
Ensure that you have logged into your Zapier account.
Go to the URL https://zapier.com/apps/document360/integrations/google-sheets/478512/update-google-sheets-rows-from-new-document360-articles
And click Try this template button
Update Google Sheets rows from new Document360 articles
1. Setting up the trigger
- Click on the Sign in to Document360 button and a new window would open with the API token field
API token generation
Obtain the Zapier token (API key) generated from the Document360 portal (Settings → Knowledge base portal → Extensions → Team collaboration), click on the generate icon, and copy the token by clicking on the copy button
- Paste the generated API key in the Zapier window and select Yes, continue button
- Now back in the Zapier action setup page click on Continue again
- In the Set up action add the correct Title and Content fields from the previously used test trigger document. Select the Category from your knowledge base
(The categories would be displayed from the main version of your knowledge base)
- Click on the Test trigger button and if the trigger is successful Continue button
2. Setting up the action
- By default, the Choose app & event section would be selected
- App → Google Sheets
- Action event → Create spreadsheet row
- Click on Continue button
- In the Google Sheets account field, click on connect a new account
- Key in your Google account credentials, click on the Allow button in the authorize window
- In the Set up action field
- Drive → My Google Drive/Choose the drive from the list
- Spreadsheet → Select the desired Spreadsheet file from your Google Drive
- Worksheet → Choose the desired worksheet in the selected spreadsheet file above
- As soon as you select the worksheet you can find the column headings listed. Select the Document360 article attribute you want to map with the respective field. Click on the Continue button
- Since you’re building a Zap that uses Google Sheets to add data there are a few things you will need to do to get that sheet ready to work with Zapier. These steps are necessary to ensure we can interact with your sheet effectively. Here is the How to guide →
Zaps are intended to only add rows to the end of the spreadsheet and not any other row.
- Select either the Test and Review or Test and Continue
Click on Turn on Zap and you’re good to go
If you rename your Sheet and/or worksheet(s) within the Sheet, you'll need to reselect them in the Zap Editor to update to the new names.
When a team member adds an article on the connected Document360, a new row would be added on the connected Google Sheets. The article title and created date information would be added in consecutive rows.