Manage Your Expenses Receipt Format for Shipping Effortlessly

Expenses receipt format for Shipping

unless you have an expensive app in your organization to help collect and report expenses when you're on the go I'm happy to share that you can build a basic workflow using Gmail and Google Spreadsheets to help you do just that welcome to the sheets 2 app show where we talk about how to tame tabular beasts into productive applications in this episode I will share a Gmail add-on anyone can copy from this video's description the lives on the G suite solution gallery and was built by my dear eric koleda the first step is to visit that link and copy the app script and then grab its manifest ID under the publish button you then visit your Gmail settings and locate the add-on section and paste the ID there and save because the script uses the property service it is able to store configuration settings specific to that script I recommend refreshing the browser so that you can spot a receipt icon on the right side of the inbox the reason it shows up on the sidebar like that is thanks to the card service which creates a sidebar interface and you can customize its title and all its key information then once installed in your Gmail settings as you travel and attach your receipts in emails I recommend using notable email subject titles to help your search later on by including the word expenses and the trip name you then have the choice to use the expensive add-on the moment you send the email from your phone or can later do a search for all email subject lines that contain the word expenses and within an email you visit the add-on from the sidebar note the add-on is only visible to you but if you wish to make the add-on public you can create one by creating a Google cloud platform account which is free to do so I would like to call out two interesting things about this lovely app for one the script is not bound to a Google sheet therefore it's called a standalone script and second upon clicking the add-on when viewing an email with an expense you have the option to create a new spreadsheet because the script uses the spreadsheet service which has built in actions to create modify or update a sheet and there you have it a summary of how to use this expenses add-on hopefully this inspires you to build your own Gmail add-on and community if you found this episode helpful please click like and subscribe to the channel for future episodes Cheers [Music]