LINK GENERATOR SCRIPT

i currently use multiple tools to send my marketing emails. to be able to use these tools, i have to manually go into each system and generate a URL to include in my email. i need a simple script - ideally in google sheets - The script should monitor my google drive folder - when a folder gets made - It will have a following structure (ProjectName >> ProjectPackage, ProjectPricing) Column 1 of the sheet will be ProjectName: When i click generate: 1. Hubspot LEAD Form - Column 2 should be form generated in Hubspot named ProjectName and the URL should be returned to Column 2. 2. Calendly: Column 3 should be an item generated in Calendly named ProjectName and the URL should be returned to Column 3. 3. TinyURL: Column 4 should be a link generated in TINYURL (I USE A CUSTM DOMAIN) with Alias ProjectPackage for google Drive URL of ProjectPackage Folder and the URL should be returned to Column 3. 4. TinyURL: Column 5 should be a link generated in TINYURL (I USE A CUSTM DOMAIN) with Alias ProjectPricing for google Drive URL of ProjectPackage Folder and the URL should be returned to Column 4. 6. JOTFORM: MAKE A COPY OF AND EXISTING JOTFORM - NAME IT PROJECT PACKAGE AND RETURN THE URL TO COLLUMN 6 Basically i am looking to join all 4 API. I am not stuck on the google sheet idea. as long as this is some kind of editable table interface . where i can add and remove columns,