This console application can import files from your personal Google Drive account into Kentico Kontent as content items or assets. It can be run without user interaction via command line for regular, scripted imports, or you can use a GUI to provide options.

Clone the repository and build it in Visual Studio, or by using

dotnet restore
dotnet build

Before you begin, you must authorize this application to access your Google Drive account:

1. Visit Google's developer console to create or select a project in the Google Developers Console and automatically turn on the API. Click Continue, then Go to credentials.
2. On the Add credentials to your project page, click the Cancel button.
3. At the top of the page, select the OAuth consent screen tab. Select an Email address, enter any Product name, and click the Save button.
4. Select the Credentials tab, click the Create credentials button and select OAuth client ID.
5. Select the application type Other, enter the name "GoogleDriveImport", and click the Create button.
6. Click OK to dismiss the resulting dialog.
7. Click the Download JSON button to the right of the client ID.
8. Move this file to the directory containing GoogleDriveImport.dll and rename it client_secret.json.

The first time you run the application, it will prompt you to authorize access. Once authorized, this will not happen again.

You must also modify the GoogleDriveImport.json file to include your Kentico Cloud Project ID, Preview API key, and Content Management API Key. These keys can be found in the API Keys page on https://app.kontent.ai. Then, move this file into the directory containing GoogleDriveImport.dll.

In the directory containing the GoogleDriveImport.dll, open a command prompt and type dotnet GoogleDriveImport.dll. If you specify no arguments, a GUI will appear and walk you through the process. You may also specify the following arguments to run the program “silently” from command line:

• -s <filename> or -source <filename> The name of the file to import, as it appears in Google Drive.
• -d <filename> or -dir <filename> The name of the folder to import contents from (nullifies -source parameter if present).
• -t <codename> or -type <codename> The code name of the content type in Kentico Kontent to create for new items.
• -e <codename> or -element <codename> The code name of the element in Kentico Kontent in which the file's contents will be inserted.
• -u or -update If passed, content items with the same code name as the imported file(s) will be updated with the new content. If not passed, new content items will always be created.

Currently, the importing of a directory’s contents is only supported when supplying parameters from command line, not using the GUI.

The following file types will be imported into Kentico Kontent as assets:

• .jpg/.jpeg
• .png
• .gif
• .svg

These file types will be imported as content items:

• Google Doc
• Google Sheet
• .txt
• .xlsx

If a spreadsheet is imported, each row of the spreadsheet will be imported as a separate content item. The first row of the spreadsheet should contain the codenames of the elements for the content type.

⚠️ The first row of the spreadsheet must contain one header with the text "Name." Other cells under this column should contain the code name of the content item to be created/updated.

Example

If you create a spreadsheet in Google Drive that contains articles like this:

You can import these articles into Kontent by running the command

dotnet GoogleDriveImport.dll -s Articles -t article -u