![]() So I am grateful I found this solution but after spending more than 12 hours trying to figure it out and gave up trying on my own and hope to get some help I am a total noob with this and I don't have an idea what I am doing and what's the logic behind power automate. All other services are paid, either document conversion services (with Integromat, Zapier and similar) or Google Sheet extensions (paid as well). Using Power Automate is the only way that seems to exist to do Excel / Google sheet conversion to CSV online for free. The source Google Sheet file should be converted to CSV every time it runs and the target CSV should be overwritten. I tried to add Get rows from Google Sheet but nothing happened.Īs I mentioned earlier, I don't mind if the whole CSV is replaced with the new Google Sheet data. I am not getting anywhere with trying to bolt on things on the workflow from above. REQUIREMENT 2 : How do I get Google Sheet converted to CSV? My google account is free (no google apps) ( I am not expecting it to append new lines or anything, just take whole new XLSX file, convert to CSV and replace the old CSV file with the latest conversion.) The target CSV file can be completely overwritten. The conversion needs to be one way only XLXS > CSV. Instead of the CSV I am still getting XLSX file (and looking at the file with Text Editor. ![]() ![]() However there is an issue with the final output file not being in the CSV format, but still Excel format. REQUIREMENT 1: How do I get Excel converted to CSV?Įven following instructions exactly e.g. Anders Jensen's Yotube video on how to do CSV conversion in Power Automate was the only one that finally helped with step by step in a sweet noob-safe manner. There is little guidance or explanation in the setup process, the error messages don't help much and there are few templates available. It's mind-boggling how PowerAutomate is difficult to use for a non-technical user compared to Zapier, Automate or Integromat, Pabbly, Apply Pie Connect and others. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |