DV360 Tools

This is a repository for a private Google Workspace add-on that can be deployed by anyone using DV360 and Google Drive/Sheets.

Push creative assets (videos, images and audio files) directly from Drive to DV360
Download reports directly from DV360 into Drive folders
Pull reports directly into google sheets

Want to add more features? Message me and I will try to add them.

The code is written in typescript and then compiled using Google Clasp
You must download Google Clasp CLI Tool to use this repo and compile it to Apps Script.
All files are contained in one folder. This makes it a little chaotic but it makes it easier when you compile into Apps Script.
Namespaces are used to import types or functions into other files. This is because in Apps Script there is no importing of modules required. All objects are available anywhere in your project. But to use Typescript and benefit from it, you need this Namespace set-up so typescript can see all of your structures and call out any potential errors. You can read more about this namespace workaround here
Find the file named configNamespace.example.ts and rename it to configNamespace.ts
This name space is used for your client secret and IDs that are needed for OAUth. You can get these from the google cloud console.
You can also store constants that you want to use throughout your project

create oauth client and add secret + id to a config file and script properties of the apps script project
enable all the google apis in the gcp project's api menu
add the scopes if they are not added automatically
you can only publish this add-on as a private add-on. a public add-on is not permitted under the license.
once the apps script project is deployed, add the web url as an authorized redirect uri within the client credentials in the oauth section of the GCP project
be careful with the endpoint after the url if you change the name of the page/file you are redirecting to. Then the end pont needs to be changed as well. https://script.google.com/macros/d/{deploymentId}/usercallback
in order to publish the add-on privately to your organization, you need to enable the google marketplace api
in the oauth consent screen section, you need to add the scopes there as well (this is in addition to the scopes you list in the appsscript project)

Name		Name	Last commit message	Last commit date
Latest commit History 7 Commits
.clasp.example.json		.clasp.example.json
.gitignore		.gitignore
AuthorizationDialog.html		AuthorizationDialog.html
Oauth-service.js		Oauth-service.js
README.md		README.md
SelectFolder.html		SelectFolder.html
appsscript.json		appsscript.json
configNamespace.example.ts		configNamespace.example.ts
downloadTyped.ts		downloadTyped.ts
getFormattedDate.ts		getFormattedDate.ts
getImageDimensions.js		getImageDimensions.js
helperFunctions.ts		helperFunctions.ts
interfaces.ts		interfaces.ts
menuDropdown.ts		menuDropdown.ts
menuFetchPicker.ts		menuFetchPicker.ts
menuScheduleFunction.ts		menuScheduleFunction.ts
package-lock.json		package-lock.json
package.json		package.json
postAssetChunked.ts		postAssetChunked.ts
postCreativeTyped.ts		postCreativeTyped.ts
pullDriveFilesToSheetsT.ts		pullDriveFilesToSheetsT.ts
reportIds.ts		reportIds.ts
sidebar.html		sidebar.html
sidebarFunctions.ts		sidebarFunctions.ts
trigger-form.html		trigger-form.html
tsconfig.json		tsconfig.json
userInteraction.ts		userInteraction.ts
userJsonStorage.ts		userJsonStorage.ts

Provide feedback