Best answer

Trigger on Gmail CSV attachment, send to GitHub as a gist


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.

icon

Best answer by robschmidt 7 June 2021, 17:23

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +9

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.