Example formula that pulls google doc ID out of the full URL
An example formula that gets the google doc id out of the full URL (in this case the field with the full google doc URL is called Proposal_Link__c but you would use the API name of custom field you created):
MID( Proposal_Link__c, find(‘/d/’,Proposal_Link__c)+