Skip to main content

Good Morning, 

 

We are building an automated report in a private github repository that gives us projected sales. We do not want to connect to our database within github for privacy reasons, so we want to:

send a file (csv) to a designated gmail account, and then copy the file into our github repository. We want to produce a new report daily so we will automate a new email being sent daily and then the file that it is being written to be replaced (written-over) by the new file. 

 

We have the data being sent to an email already, we are looking for guidance with copying the data from the email to the repository daily. 

 

If anyone has any guidance or recommendations that would be much appreciated !

 

Thank you all for the help, I am still a novice when it comes to making my own Zaps.

Hi @nickvbox ,

Here’s how you can get this accomplished in Zapier:

  1. Trigger: Set up “New Attachment” using Gmail app in Zapier
  2. Action: Use formatter>utilities>CSV to extract the csv data as line-items/row items.
  1. Action: Use “Create Gist” integration from github app in Zapier and append the line-item data in the file content
  1. To delete the old record, I believe you have to use a google sheet/storage by zapier to store the gist ID and then when it runs the next time it’ll delete the gist using API

My csv file has over 50,000 rows, which is clearly over the utilities line max. Is there anyway to overcome this or a work-around? It does only have 2 columns.