Skip to main content

Hello!

I am trying to find a way to automatize the following process and I would love to get some ideas:

  • clean an excel file containing data
    • remove unnecessary columns
    • clean-up text in a specific column (I usually do this using text-to-column and using “(“ and “:” as a delimited to keep the text I need;
  • check data in columns A and B of the excel file with data contained in a master list (which could be another excel file or any other solution - for example an online SQL database);
  • remove from columns A and B any data that is already available in the master list;
  • combine data from columns A and B together;
  • split the content of these columns in blocks of 100 cells each.

Ideally I would love to create Amazon Ads with one ad per each 100 cells (keywords), but I don’t think that Zapier syncs with Amazon Ads.

Thanks a lot!!

Hey @botolo!

Thanks for writing into the Zapier Community! 

Hmm... I’m not sure of this level of automation would be possible in a Zap 😟

You could see the available triggers/actions for Microsoft Excel here: https://zapier.com/apps/excel/integrations#triggers-and-actions - new rows can trigger a Zap, and you can update rows, but there is no functionality to remove rows unfortunately.

You may also try experimenting with the Formatter/Import CSV action - after emailing yourself the file as a csv for example, to see if that gives you the data in a usable format. Read more: https://zapier.com/help/create/format/import-csv-files-into-zaps 

Hope this helps somewhat! 

Terms & Conditions