Respect to all.
I would like you to give some advice
from the pdf file that is in the folder in google drive, I move it to google sheets. Of course, I would format certain data as desired (delete some columns), how to do that, please?
Welcome to the Make community!
You can try to remove the unnecessary data before moving it to Google Sheets, or you can try to use the BatchUpdate endpoint to delete the columns from a sheet.
You’ll need to use Google Sheets “Make an API Call” module to call the spreadsheets.batchUpdate endpoint to request for a “DeleteDimensionRequest”.
Deletes the dimensions from the sheet.
2 Likes