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)+3, find(‘/edit’,Proposal_Link__c) – find(‘/d/’,Proposal_Link__c)-3)