GoogleMailV2CLIAPI@2.5.1 ロゴSubZapCLIAPI@0.11.0 ロゴGoogleSheetsV2API ロゴWebHookAPI ロゴFilterAPI ロゴGoogleDriveCLIAPI@1.11.0 ロゴGoogleDriveCLIAPI@1.11.0 ロゴGoogleSheetsV2API ロゴWebHookAPI ロゴ

2023 FOIA to Google Sheets

This zap takes emails sent to a specific alias email address I have in Gmail that is set up to automatically label it as "FOIA" - this is important because the zap is triggered by a new email labeled "FOIA." The subject line is the tracking ID that I set up in a separate process to automatically be created every time I file a new FOIA (this is just done through a Google Form and the google sheets add-on "Copy Down" to automatically pull down the formulas to new rows in the sheet). The "sub zap" for this is a search step to search for the subject line from the email in my FOIA tracking spreadsheet. Then it creates a folder on Google Drive with that same ID, uploads the email attachment and puts a link to that folder in the same row of my FOIA tracking sheet.

Madison Hopkinscreated by Madison Hopkins

This Zap uses a private app.

This means the developers of this app haven’t completed our full quality assurance steps. Zapier has limited details on this app and as a result can’t offer support for it. If you have questions about this app, please contact the person who gave you access to this Zap.
How Zapier works (57 sec)
How Zapier works (57 sec)
Try this Zap FREE for 14 days

大小の企業から信頼されています

This Zap works in 9 steps

  • 4.5 minutes to set up
  • Get back 1.2 hrs /week
  • 517 people use this app pairing

This Zap uses the following 6 apps

  • Gmail ロゴ
  • Sub-Zap by Zapier ロゴ

More ways to use these popular apps!

Check out all the other ways you can connect Gmail and Sub-Zap by Zapier.
Learn More