Free & Open-Source Invoice Generator - No Sign-Up, No Ads, Instant PDF Export, 100% In-Browser, and Fully Customizable Templates.
TypeScript fintechinvoiceinvoice-generatorinvoice-pdfinvoice-templateinvoicesnextjsopen-sourcequotesreactreact-pdf-rendererself-hostedshadcn-uitailwindcsstypescript
import { Readable } from "node:stream";
import { type drive_v3, google } from "googleapis";
import { z } from "zod";
import { env } from "@/env";
type GoogleDriveFile = drive_v3.Schema$File;
interface DriveFolderRef {
id: string;
webViewLink: string;
}
export interface InvoiceFolderResult {
folderToUploadInvoices: DriveFolderRef;
googleDriveFolderPath: string;
}
/**
* Convert Google Drive File object to DriveFolderRef.
* Throws if file missing required fields.
*
* @param file - Google Drive file (should be a folder)
* @returns DriveFolderRef with id and webViewLink
*/
function toDriveFolderRef(file: GoogleDriveFile): DriveFolderRef {
if (!file.id) {
throw new Error("Google Drive folder is missing id");
}
if (!file.webViewLink) {
throw new Error("Google Drive folder is missing webViewLink");
}
return { id: file.id, webViewLink: file.webViewLink };
}
const FolderInputSchema = z.object({
parentFolderId: z.string().min(1),
month: z
.string()
.regex(/^(0[1-9]|1[0-2])$/, "Month must be between 01 and 12 (MM format)"),
year: z.string().regex(/^\d{4}$/, "Year must be in YYYY format"),
});
type FolderInput = z.infer<typeof FolderInputSchema>;
let cachedDrive: drive_v3.Drive | undefined;
export async function initializeGoogleDrive() {
if (cachedDrive) {
return cachedDrive;
}
const googlePrivateKey = env.GOOGLE_DRIVE_PRIVATE_KEY.replaceAll(
String.raw`\n`,
"\n",
);
const auth = new google.auth.GoogleAuth({
credentials: {
client_email: env.GOOGLE_DRIVE_CLIENT_EMAIL,
private_key: googlePrivateKey,
},
scopes: ["https://www.googleapis.com/auth/drive"],
});
cachedDrive = google.drive({ version: "v3", auth });
return cachedDrive;
}
async function createFolder(
drive: drive_v3.Drive,
folderName: string,
parentFolderId?: string,
): Promise<GoogleDriveFile> {
const fileMetadata = {
name: folderName,
mimeType: "application/vnd.google-apps.folder",
...(parentFolderId && { parents: [parentFolderId] }),
};
const response = await drive.files.create({
requestBody: fileMetadata,
fields: "id, name, mimeType, webViewLink",
});
if (!response.data.id) {
throw new Error("Failed to create folder");
}
return response.data;
}
/**
* Converts a Buffer to a Readable stream for efficient streaming to Google Drive API
* @param {Buffer} buffer - The input buffer containing file data
* @returns {Readable} A readable stream created from the buffer using Node's Readable.from()
*/
const bufferToStream = (buffer: Buffer): Readable => {
return Readable.from(buffer);
};
export async function uploadFile({
googleDrive,
fileName,
fileContent,
folderId,
}: {
googleDrive: drive_v3.Drive;
fileName: string;
fileContent: Buffer;
folderId: string;
}) {
const fileMetadata = {
name: fileName,
parents: [folderId],
};
const media = {
mimeType: "application/pdf",
body: bufferToStream(fileContent),
};
const response = await googleDrive.files.create({
requestBody: fileMetadata,
media,
fields: "id, name, mimeType, webViewLink",
});
if (!response.data.id) {
throw new Error("Failed to upload file");
}
return response.data;
}
export async function createOrFindInvoiceFolder({
googleDrive,
...input
}: {
googleDrive: drive_v3.Drive;
} & FolderInput): Promise<InvoiceFolderResult> {
// Validate input
const validatedInput = FolderInputSchema.parse(input);
// First, try to find or create the year folder
const yearFolderName = validatedInput.year;
const yearFolderQuery =
`name = '${yearFolderName}' and mimeType = 'application/vnd.google-apps.folder' and '${validatedInput.parentFolderId}' in parents and trashed = false` as const;
const yearFolderResponse = await googleDrive.files.list({
q: yearFolderQuery,
fields: "files(id, name, mimeType, webViewLink)",
spaces: "drive",
});
let yearFolder: GoogleDriveFile;
if (yearFolderResponse.data.files?.length) {
// if the year folder already exists, use it
yearFolder = yearFolderResponse.data.files[0];
} else {
// if the year folder does not exist, create it
yearFolder = await createFolder(
googleDrive,
yearFolderName,
validatedInput.parentFolderId,
);
}
// Then try to find or create the month folder inside the year folder
const monthFolderName = `${validatedInput.month}.${validatedInput.year}`;
const monthFolderQuery =
`name = '${monthFolderName}' and mimeType = 'application/vnd.google-apps.folder' and '${yearFolder.id}' in parents and trashed = false` as const;
const monthFolderResponse = await googleDrive.files.list({
q: monthFolderQuery,
fields: "files(id, name, mimeType, webViewLink)",
spaces: "drive",
});
let monthFolder: GoogleDriveFile;
if (monthFolderResponse.data.files?.length) {
// if the month folder already exists, use it
monthFolder = monthFolderResponse.data.files[0];
console.info(
"\n\n________month folder already exists, using it: ",
monthFolder,
{ monthFolderName, yearFolderName },
"\n\n",
);
} else {
// if the month folder does not exist (new month), create it
if (!yearFolder?.id) {
throw new Error(
"[createOrFindInvoiceFolder] Google Drive year folder is missing id",
);
}
monthFolder = await createFolder(
googleDrive,
monthFolderName,
yearFolder.id,
);
}
// Finally, try to find or create the invoices folder
const invoicesFolderQuery =
`name = 'invoices' and mimeType = 'application/vnd.google-apps.folder' and '${monthFolder.id}' in parents and trashed = false` as const;
const invoicesFolderResponse = await googleDrive.files.list({
q: invoicesFolderQuery,
fields: "files(id, name, mimeType, webViewLink)",
spaces: "drive",
});
let folderToUploadInvoices: GoogleDriveFile;
if (invoicesFolderResponse.data.files?.length) {
// if the invoices folder already exists, use it
folderToUploadInvoices = invoicesFolderResponse.data.files[0];
} else {
// if the invoices folder does not exist, create it
if (!monthFolder?.id) {
throw new Error(
"[createOrFindInvoiceFolder] Google Drive month folder is missing id",
);
}
folderToUploadInvoices = await createFolder(
googleDrive,
"invoices",
monthFolder.id,
);
}
const googleDriveFolderPath = `/${yearFolder.name}/${monthFolder.name}/${folderToUploadInvoices.name}`;
console.info(
"\n\n________invoice to upload Google Drive folder path: ",
googleDriveFolderPath,
"\n\n",
);
const folderToUploadInvoicesRef = toDriveFolderRef(folderToUploadInvoices);
return {
folderToUploadInvoices: folderToUploadInvoicesRef,
googleDriveFolderPath,
};
}