Convert Google Doc hyperlink in a cell to an attachment
We have some sheets containing very large numbers of hyperlinks to Google Documents. The links are in a single column, with one hyperlink in each row. This procedure has been followed for several years, rather than using the attachments facility, for internal security reasons which no longer apply.
Our organisation is now moving away from Google in favour of Office 365, which means that whilst all the documents will be migrated to OneDrive and converted to Word format, the URLs will no longer work. One possible solution which has occurred to me is to run some automated process which would use the hyperlink in a cell to extract the Google Doc and convert it to an attachment (in say DOCX or PDF format) to be stored against that row.
A long shot I know, but can anyone think of a way to achieve this? An alternative will be to retain a Google account purely to store the legacy Google docs.