Google Drive files list in Google Sheet

$10-30 USD

Closed

Posted

6 months ago

$10-30 USD

Paid on delivery

I have a google sheet, with some data (rows and columns). I want one column to have dropdowns in all cells. These drop downs will show list of files from a Google Drive folder and sub-folders. User should be able to select a file from this dropdown. This will become a hyperlink to the file. i.e. clicking this link will open the file picked from the dropdown. I need the script, so that I can configure the name of Google Drive folder. Automatic updates: The list should be updated automatically, so any changes in the Google Drive folder will be reflected in the Google Sheet dropdown. Example: My Google Drive has following two files and two folders containing another 3 files. So the dropdown should show the following: [login to view URL] [login to view URL] Folder1/[login to view URL] Folder1/[login to view URL] Folder2/[login to view URL] If you want, i can give you access to my google drive folder. Ideal skills and experience for this job: - Proficiency in working with Google Drive and Google Sheets. - Experience in automation and data synchronization between Google Drive and Google Sheets. - Attention to detail to ensure accurate and up-to-date file listing. Please provide examples of similar projects you have completed in the past.

Google Sheets

Google Docs

Project ID: 37497790

About the project

18 proposals

Remote project

Active 4 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

18 freelancers are bidding on average $41 USD for this job

@akritisood94

Hi there! My name is Akriti and I am a Google Drive and Google Sheets expert. I understand you need one column in your Google Sheet to have dropdowns that show list of files from a Google Drive folder and sub-folders. The user should be able to select a file from this dropdown and have it open using a hyperlink. I can help you with this project! With my expertise in working with Google Drive and Sheets, along with automation and data synchronization between the two services, I am confident that I can deliver an accurate, up-to-date list that will automatically be updated as changes occur in your Drive folder. I would be delighted to discuss this project further with you. Please feel free to contact me if you have any questions or would like me to provide more information about my skills and experience.

$30 USD in 1 day

5.0

(22 reviews)

5.1

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

$80 USD in 1 day

5.0

(8 reviews)

5.3

@kanwalrafique

Hello, I'm a skilled Google Apps Scripts developer with five years of experience. My experience includes creating solutions for Google Workspace apps in Apps Scripts, including Google Sheets, Google Drive, and Gmail. I can create an Apps Script for your Google Sheets that will allow you to configure drop-down menus for a specific column to show the contents of a designated folder from your Google Drive. Selecting a file from a drop-down menu will make a hyperlink appear in another column. The drop-down will be updated each time you open it. I don't need access to your Google Drive folder to create this functionality. So, if you'd like to discuss your project with me, send me a message, even when I appear offline. I typically reply within a few minutes when online and in a few hours when offline.

$40 USD in 2 days

5.0

(6 reviews)

3.8

@zafarfarooq612

Hello, I am excited to bid on your project to create dynamic dropdowns in Google Sheets linked to Google Drive files. Leveraging my proficiency in Google Drive and Google Sheets, I will craft a script that allows you to configure the folder name, ensuring an efficient and user-friendly solution. With a keen eye for detail, I'll ensure accurate and automatic updates, reflecting any changes in the Google Drive folder within the Google Sheet dropdown. I have successfully undertaken similar projects, showcasing my expertise in automation and seamless data synchronization. I look forward to delivering a solution that enhances the functionality of your Google Sheet. Regards, Zafar

$20 USD in 1 day

5.0

(5 reviews)

3.1

@subinpvasu

Hi, I'm interested in your requirement. I have good experience of web development with Google Apps Scripts We can discuss further on chat. Thanks!

$50 USD in 1 day

5.0

(2 reviews)

3.1

@vw1514518vw

Ready to develop the required for creating dynamic dropdown list for google drive folders/files with name, hyperlink in google sheets.

$50 USD in 1 day

5.0

(1 review)

1.4

@abdulbasitone

Hello! My name is Abdul, and I'm a professional data analyst with over 10 years of experience in the field. I understand that you are looking for someone to create a script that will configure the name of your Google Drive folder so that the list in your sheet will be updated automatically when changes are made to your folder. I believe I am the perfect person for this project! My skillset includes proficiency in working with Google Drive and Google Sheets, experience in automation and data synchronization between Google Drive and Sheets, attention to detail to ensure accurate and up-to-date file listing, as well as the ability to configure name of a folder accurately. Additionally, I provide automatic updates for my lists so that any changes made to your folder will be reflected in the sheet quickly. If you'd like me to provide access to your Google Drive folder so we can get started on this project together please don't hesitate to reach out!

$35 USD in 1 day

0.0

(0 reviews)

0.0

@muradeltaher

Hello, my name is Murad and I am an experienced freelancer with skills in working with Google Drive and Google Sheets. I understand exactly what you are looking for in terms of a script that can configure the name of the Google Drive folder and provide automatic updates so that any changes made to the folder will be reflected in the list of files. As such, I believe I would be the best fit for this project. I have extensive experience in data entry, architecture, Excel, and WordPress that would be valuable for this project. Additionally, I pay close attention to detail so that accurate and up-to-date file listing is ensured as well as timely updates of dropdowns when necessary. If you want someone who can deliver high quality results within deadlines please feel free to contact me directly. Thank you for considering me for this project!

$30 USD in 1 day

5.0

(1 review)

0.0

@JohnITIntern

Hello! I'm an high school student working in an IT Internship for a school district. I have created several project through google sheets regarding inventory and project management. I am also familiar with Google Apps Script which I would mostly likely add onto this Google Sheet. Please feel free to contact me!

$10 USD in 7 days

0.0

(0 reviews)

0.0

@jinufeb14

Hello, my name is JINU and I am an experienced software engineer specializing in creating efficient and reliable solutions for a variety of needs. With a background in cloud technology, I am well-versed in utilizing the latest tools and platforms to maximize performance and scalability. I understand that you are looking for someone to create a script that will allow you to configure the name of your Google Drive folder so that it can be updated automatically with any changes made to the folder. Additionally, I can ensure accurate and up-to-date file listing by ensuring that dropdowns in your Google Sheet column contain a list of files from a specific Google Drive folder and sub-folders. I believe I am the perfect person for this project! My skillset includes proficiency in working with Google Drive and Sheets as well as experience in automation and data synchronization between Drive and Sheets. This combination makes me well-suited to deliver accurate file listing with automatic updates.

$50 USD in 7 days

0.0

(0 reviews)

0.0

@yatisalleh

Hi! I am a skilled freelancer with extensive knowledge in working with Google Drive and Sheets. My proficiency in this area allows me to maintain accurate file listings while ensuring timely updates. This particular project would be a breeze for me as I have previously done similar projects with success. If you would like me to discuss this project further or for more information please don't hesitate to reach out to me directly. Thank you for considering me for this job!

$20 USD in 7 days