Summarize this article:

Log in to Google, if you have not already done so.  It's in the menu at the top of the page.   It's the app with a dark blue image, and two light blue folders. This installs the add-on to your Google Sheet document. It's in the menu at the top of the page. This will connect to your Google Drive account.  This is the option you have to click even though you will be selecting a folder.  When folder is finished copying, it will appear in your Google spreadsheet. You can enter a prefix or a suffix to appear before or after the copied folder name, to distinguish it from the original. Go to https://drive.google.com in a new browser tab and you will see your newly copied folder.
Go to https://sheets.google.com in a web browser. Click  to open a new blanks spreadsheet. Click the Add-ons. Click Get Add-ons . Type copy folder in the search bar and press ↵ Enter. Click + Free next to the "Copy Folder" add-on. Click Allow. Click Add-ons. Select Copy Folder. Click Select a folder. Click Select a file. Select the folder you want to copy. Click Copy. Go to your Google Drive.