Hey everyone! I’m stuck trying to move a Google Doc into Airtable using Integromat. The main issue is that Airtable needs a ‘File URL’ for its attachment field, but I can’t figure out how to get that from Google Docs.
I tried using the ‘Export Links: Application PDF’ option, but it just redirects to the Google Docs login page when I try to open the file in Airtable.
Then I tried the ‘Download a Document’ module in Integromat, but it only gives me the file data and name, not a URL.
Has anyone found a workaround for this? I’m really hoping to automate this process. Any tips or tricks would be super helpful! Thanks in advance!
hey josephk, i had the same prob. try using the ‘Download a Document’ module then follow it with an http post to airtable’s upload endpoint. include the file data in the body to get the file url for attaching. hope that helps!
I’ve encountered this issue before. One effective solution is to utilize Google Drive’s ‘webViewLink’ or ‘webContentLink’ instead of direct Google Docs links. First, move your Google Doc to Drive, then use the Google Drive ‘Get a File’ module in Integromat to retrieve these links. The ‘webContentLink’ typically works well for Airtable attachments. Remember to set file sharing permissions appropriately. This method has consistently worked in my automation workflows, providing a stable URL for Airtable to access the file content directly from Google’s servers.
I’ve dealt with this issue in my workflows, and here’s what worked for me: instead of using Google Docs directly, convert the doc to a PDF and store it in Google Drive. Then, use the Google Drive ‘Create Sharing Link’ module in Integromat to generate a public URL. This URL can be directly used in Airtable’s attachment field.
The key is ensuring the sharing settings are set to ‘Anyone with the link can view.’ This approach bypasses the login redirect issue and provides a stable link for Airtable. It’s been reliable in my automated processes, though it does add an extra step of PDF conversion. Just remember to handle any sensitive information appropriately when using public links.