I am sent a weekly pace report via Gmail as an xlsx attachment. I need to be able to extract some of the values from this sheet to plug into a separate Google Sheet. I have several Zaps that do this successfully, by first uploading the xlsx file to Google Drive, and then in the next step turning that file into a Google Sheet.
However, this particular attachment contains formulas that reference a sheet on the sender’s desktop - the formulas are useless to me. When I open these attachments in Excel, it gives me the option to only import values as opposed to formulas. But in my Zap the file is automatically uploaded to Google Drive with the formulas intact. Is there any workaround for this?
Question
Create Google Sheet from xlsx file with values, not formulas?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.