Overview

Suppose you want to extract the ID of all items that reside in a folder of Google Drive. There are many ways to do this, like manually copying from each file or programmatically. I will guide you on how to do this using a program in C#

Requirements

  • Shared Google Drive Folder id /URL
1

https://drive.google.com/drive/u/4/folders/1759s8Jule46RCPypiQ5y3wLh5aCPlrK6

Steps 1

Open IDE or code editor. Create a new console app using IDE or through this command in terminal

1

dotnet new console -n MyApp

Steps 2

Install HtmlAgilityPack in project using one of the below commands

Package Manager

1

NuGet\Install-Package HtmlAgilityPack -Version 1.11.60

Command Line Interface

1

dotnet add package HtmlAgilityPack --version 1.11.60

If you are using Polyglot Notebook in VS Code

1

\#r "nuget: HtmlAgilityPack, 1.11.60"

Right-click on project and choose Edit Project File

1
2
3

  <ItemGroup>
    <PackageReference Include="HtmlAgilityPack" Version="1.11.61" />
  </ItemGroup>

Your .csproj file should look similar to this

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>net8.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="HtmlAgilityPack" Version="1.11.61" />
  </ItemGroup>

</Project>

Steps 3

Open Program file and add the below function snippets.

1
2
3
4
5
6
7

string GetHtml(string url)
{
    using (WebClient client = new WebClient())
    {
        return client.DownloadString(url);
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

List<string> ExtractFileList(string html)
{
    var fileList = new List<string>();

    // Load the HTML document
    HtmlDocument doc = new HtmlDocument();
    doc.LoadHtml(html);

    // XPath to select elements containing file ID and name
    var nodes = doc.DocumentNode.SelectNodes("//div[@data-id]");

    if (nodes != null)
    {
        foreach (var node in nodes)
        {
            // Extract file ID and name attributes
            string id = node.Attributes["data-id"].Value;
            string name = WebUtility.HtmlDecode(node.GetAttributeValue("data-tooltip", ""));

            fileList.Add(id);
        }
    }

    return fileList;
}

Step 5

  • Replace folderId value with Your Drive folder Id
  • Or Replace url value with Your Drive Folder Url
  • Then Call GetHtml Function To Get Html Content
  • ExtractFileList to Get List Of Only
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

// Replace '1759s8Jule46RCPypiQ5y3wLh5aCPlrK6' with the ID of your Google Drive folder
string folderId = "1759s8Jule46RCPypiQ5y3wLh5aCPlrK6";

// URL of the Google Drive folder
string url = $"https://drive.google.com/drive/folders/{folderId}";

// Fetch the HTML content of the Google Drive folder link
string html = GetHtml(url);

// Extract the file IDs from the HTML
var fileList = ExtractFileList(html);

Step 6

Iterating over fileList to Print it to Console.

1
2
3
4

foreach (var file in fileList)
{
    Console.WriteLine($"File ID: {file}");
}

Full Code

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

using HtmlAgilityPack; 
using System.Net;


// Replace '1759s8Jule46RCPypiQ5y3wLh5aCPlrK6' with the ID of your Google Drive folder
string folderId = "1759s8Jule46RCPypiQ5y3wLh5aCPlrK6";

// URL of the Google Drive folder
string url = $"https://drive.google.com/drive/folders/{folderId}";

// Fetch the HTML content of the Google Drive folder link
string html = GetHtml(url);

// Extract the file IDs from the HTML
var fileList = ExtractFileList(html);

// Output the file list
foreach (var file in fileList)
{
    Console.WriteLine($"File ID: {file}");
}
string GetHtml(string url)
{
    using (WebClient client = new WebClient())
    {
        return client.DownloadString(url);
    }
}
List<string> ExtractFileList(string html)
{
    var fileList = new List<string>();

    // Load the HTML document
    HtmlDocument doc = new HtmlDocument();
    doc.LoadHtml(html);

    // XPath to select elements containing file ID and name
    var nodes = doc.DocumentNode.SelectNodes("//div[@data-id]");

    if (nodes != null)
    {
        foreach (var node in nodes)
        {
            // Extract file ID and name attributes
            string id = node.Attributes["data-id"].Value;
            string name = WebUtility.HtmlDecode(node.GetAttributeValue("data-tooltip", ""));

            fileList.Add(id);
        }
    }

    return fileList;
}

You Can Just Paste Full Code And Check If there is any error you are Getting.

Then You can Hover Over Error And it Will Prompt Show Potential Fixes.

And Choose HtmlAgilityPack.

For similar type of Error you do The Same.

For More Follow below Videos