I have a workflow that pulls an Excel attachment from an email in Gmail and saves it into Google Drive as a Google Sheet. One column of my data is invoice numbers, but it’s stored as text in the original file. I have to have this as a number, so I’m having to go into the file and format that column to number.
Is there a way for Zapier to automate this task?
+14Hi
For us to have more info, post screenshots about what you are referring related to a specific example.
Hi
For us to have more info, post screenshots about what you are referring related to a specific example.
It’s current formatted as automatic and I have to manually change it to the green highlight.
+14
If possible, that would likely involve using the GSheets API: https://developers.google.com/workspace/sheets/api/guides/concepts
Zap action: GSheets - API Request
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
